Want Some Formula Fun? Course we do it is #formulafriday time. Here is a great one, I use it quite often. How to find how many numbers in your list are greater than the average. Think about it you….. can use this formula to find out
- how many students scored higher than average
- how many employees are paid higher than the average
- how any sales reps made sales higher than the average
The COUNTIF Syntax
range – is the range of cells that you want to count based on the criteria
criteria – is the criteria used to determine which cells to count
An Example Using COUNTIF
Let’s take an example and find out how many employees are paid higher than the average salary.
First let’s calculate the average salary. Easy. See below.
We have used a value in another cell as part of the criteria, so we have used the ampersand (&) character to concatenate the cell value and the greater than symbol. As we are using a text string ( the greater than symbol) we must use the double quotation marks with it.
Now we have the average salary we can calculate using COUNTIF how many employees earn more than the average.
Do you want to learn more formulas, in a fast and fun way?
75 of the most frequently used Excel formulas explained with examples. Get your GO FASTER STRIPES with this fantastic E- Book.
If you want see see all of the blog posts in the #formulafriday series then you can click on this page right here.
If you want MORE Excel and VBA tips then sign up to my monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips. If you want to see all of the blog posts in the Formula Friday Series you can do so by clicking on the link below.