Advance Excel || 8) COUNTIF Function in MS Excel || Example-1. Name State Sales in (Rs.) Adrian Gujarat 5000 Nathan Goa 2500 John Kerala 1250 Gerard Haryana 1875 Zacharias Delhi 9872 John Tamil Nadu 7800 Fexlix Gujarat 18700 Isaac Gujarat 458 Kane Punjab 22400 Example Results Sales over Rs. 4500 ? Sales below Rs. 4500 ? Sales by John ? Sales in Gujarat ?
On my Blog, you will find tutorials of various accounting software's and many more such things Like, M S Office, CCC, Advance Excel, Digital Marketing, TallyPrime (GST), Foreign Accounts (QuickBooks - CANADA & USA , Sage - UK & Myob - Australia), SAP (FICO & MM), PGDCA (HTML, CSS, C, C++, JAVA, JAVASCRIPT, PYTHON, SQL, ASP.NET Core Web Application using Microsoft Visual Studio 2022 (C# .NET Framework.)