count multiple condition in range in Excel

Q22. In Excel, how can I find the count of records that meet multiple conditions in my raw data table?

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 excel count multiple condition in range

 

You can find similar Excel Questions and Answer hereunder

1) How can I find the slab in which a given value fits?

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

3) Can I determine the number of times a character appears in a cell using formula?

4) How can I find the count of records that meet a given condition in my raw data table?

5) How can I find the sum of records that meet a given condition in my raw data table?

6) How can I add a Prefix to a set of numbers in a range?

7) Split string into multiple columns in Excel

8) How can I edit data in multiple WorkSheets together?

9) Find and count instances of a character in a string in Excel

10) How can I quickly remove all blank cells in a data range?

11) Is there a way to easily shade alternate rows in a data range for improving readability?

12) how do you enter multiple line in a cell in Excel

13) How can I get the count of number of series in a Chart using VBA?

14) How can I clear all formats (formats alone not data) from a range of cells?

15) Vlookup to return max value from multiple hits in Excel