Count multiple condition in range in Excel

For example, I want to get the count of number of students that fall in each grade given their marks and grading table.

To do it in Excel, here is the answer:

a) Enter the formula =COUNTIFS($E$3:$E$12,">=" & H3,$E$3:$E$12,"<=" & I3) where E3:E12 has marks data, H3 and I3 represent the minimum and maximum marks for a given grade.

The above formula checks and counts the number of marks that fall with value contained in H3 and I3 (both numbers inclusive).

excel count multiple condition in range

b) Copy the formula as needed for the remaining grade definitions.

excel count multiple condition in range


You can find similar Excel Questions and Answer hereunder

1) How can I enter multiple lines of data in a cell?

2) How do I get the 2nd highest number in a range of numbers?

3) How do I find the median salary of employees with the same skillset in my Organization?

4) How can I get an estimate of Standard Deviation of a sample dataset?

5) Sumifs with date range as criteria in Excel

6) How to rename multiple sheets easily with VBA

7) How can I remove hyperlinks from a range of cells?

8) what are the main range object and what can the range objects do in VBA

9) Vlookup to return multiple values in same cell in Excel

10) Split one long column into multiple smaller columns in Excel


Here the previous and next chapter