A COUNTIF formula is used to count the number of occurrences based on a specific criteria. A COUNTIF is written as follows:
=COUNTIF(Range, Criteria)
So, let's say you have values in range B1:B100 that determines the number of times each item was sold. So, if you want to check how many items have been sold more than 20 times, your formula would be:
=COUNTIF(B1:B100, ">20")
If you wanted to see how many items had sold between 30 and 50 times, you would need to use a COUNTIFS, which is written as follows:
=COUNTIFS(Criteria_Range1, Criteria1, Criteria_Range2, Criteria2...)
Your formula to find the number of occurrences between 30 and 50 would then be (including 30 and 50):
=COUNTIFS(B1:B100, ">=30", B1:B100, "<=50")
COUNTIF / COUNTIFS are used pretty regularly - another simple formula that is easy to use yet very effective.
No comments:
Post a Comment