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).
b) Copy the formula as needed for the remaining grade definitions.