Continuing where I had left last week on the count functions... let me introduce to you one more count function
Lets have a look at the CountIf function. CountIf alows you to count based on a given criteria. For example you want to count the number of employees with sale above $1000 in the below data
The formula which you can apply will be
=COUNTIF($C$2:$C$9,">1000")
In this formula ">1000", is the criteria, which comprises or the operator greater than. All the relational operators like >, <, <=, >= & <> can be used. These is no need to write equal to, if you want the exact match of 1000 (use "1000" in that case).
No comments:
Post a Comment