COUNTIF function
Use COUNTIF, one of the popular function to count the number of cells that meet a criterion;
example, to count the number of times a particular city appears in a customer list.
In its simplest form, COUNTIF says:
=COUNTIF(Where do you want to look?, What do you want to look for?)
For example:
=COUNTIF(A2:A5,"name of sales person")👇

Result will be👇

The best part of this function is you can use it in many different ways.
Lets say you have a table with many numbers in a columns and you just want to count only those numbers which are greater than equal to 32
Formulae bar:
=COUNTIF(B2:B5,">=32")
B2:b5 is ranger here
You can use any criteria...rest is your creativity 😃
No comments:
Post a Comment