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 Sumif by Criteria

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


Back to Tools for Excel Tables Start

In order to understand the SUMIF option functionality, Think about the following situation:

We have a table where it shows info of a teacher.
We can watch the fields: Section, Students (number of students) and Status (Approved, Unapproved)
Now, we want to know, how many students approved the course. Previously, we have built a small table containing possible criteria. (see the below image):
We open the corresponding dialog box and fill the data.
Finally we press the Ok button. That is all.



The results are showed next. They are 100 approved students and 100 unapproved.



Logically, we have used a small table, for this example. but imagine that you must do a similar task, but to a table with 5,000 records. Worrying, don't you?
With this tool, the worrying is over.

In this case we have summed those records classifying in 2 groups "Approved" and "Unapproved", according to the criteria table.
This tool, also, allows you to performance the following opertions: Equal, Greater, Equal or Greater, Less, Equal or Less than, Seaching of text, etc

Back to Tools for Excel Tables Start

Tools for Excel Tables    Secure Payment Options

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.

Software Categories Search Software

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