The Excel COUNTIFS function returns the count of cells that meet one or more criteria. COUNTIFS can be used with criteria based on dates, numbers, text, and other conditions.
Syntax
COUNTIFS (range1, criteria1, [range2], [criteria2], ...)
Arguments
range1 - The first range to evaulate.
criteria1 - The criteria to use on range1.
range2 - [optional] The second range to evaluate.
criteria2 - [optional] The criteria to use on range2.
Let us try to understand with an example.
Here we have used COUNTIFS function to extract the number of students studying in section "A" with marks in Math >60 and marks in Physics >60
In this way multiple conditions can be imposed but the length of range in all conditions must be same.
0 comments:
Post a Comment
If you have any queries, please let me know.