In: Computer Science
How to use the COUNTIFS Function in Excel. Need to calculate the number of days. Independent Challenge 4. #g page 127 Microsoft Excel 2016 Comprehensive
To use the COUNTIFS function, we need to specify the pairs of ranges & the condition to be satisfied to include a cell in the counting. Below i am demonstrating this with an example where we need to count only the A grades achieved by students of class 9 in Science subjects. So we have 3 conditions and thus need to use 3 ranges. As you can see in the formula, firstly we specify the range where classes are stored which is B2:B11 then we give the value of the class that we need to count which is 9. Similarly we specify other conditions.
=COUNTIFS(B2:B11,9,C2:C11,"Science",D2:D11,"A")
Example:
(*Please up-vote. If any doubt, please let me know in the comments)