Count record in range in Excel

For example, I want to find in each quarter how many salespersons have met their Quarterly Target of $3500.

To do it in Excel, here is the answer:

a) Enter the formula =COUNTIF(E5:E14,">3500") where E5:E14 corresponds to sales data of all the employees and ">3500" represents the criteria to be met.

excel count record in range

b) Copy the formula as needed for the data pertaining to other quarters.

excel count record in range


You can find similar Excel Questions and Answer hereunder

1) How can I add a Prefix to a set of numbers in a range?

2) Can I determine the number of times a character appears in a cell using formula?

3) How do I get the 2nd highest number in a range of numbers?

4) How can I quickly remove all blank cells in a data range?

5) Find and count instances of a character in a string in Excel

6) How can I get an estimate of Standard Deviation of a sample dataset?

7) How can I find the count of records that meet multiple conditions in my raw data table?

8) How can I fill a range of cells with incremental times?

9) How do I find the median salary of employees with the same skillset in my Organization?

10) How can I find the sum of records that meet a given condition in my raw data table?


Here the previous and next chapter