Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Excel Countif by Criteria

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

 

Back to Tools for Excel Tables Start

COUNTIF    
 
In this case, we have a table with the names and the score of each one of them, also a criteria table.
We want to know, how many students were approved with 8,9 and 10 score.
In order to solve this problem, we open the dialog box of our tool.

 

 

Finally we press the Ok button. The result is showed below:

 

 

We can realize that they are 5 people with score 8, there are 9 people with score 9 and 1 person with score 10.
In this case we have counted those values equal to the small criteria table. Simple!!

This tool, besides, allow us to make operations, such as Greater, Less, Equal or greater than, Equal or less than, searching of text, etc.

Now, imagine all of the time and work that you would save if this table was 10 or

Back to Tools for Excel Tables Start

Tools for Excel Tables    Secure Payment Options

Pricing:
1 $89.95 USD
2 - 5 Licenses $79.95 USD
6 - 9 Licenses $72.50 USD
10+ Licenses $54.95 USD

Free Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH!  Purchases MUST be made via this site.

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us