Excel Made Easy

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

Excel Made Easy was founded in 2002. Excel Made Easy is a service to people looking to learn Microsoft Excel or any other spreadsheet SW on the market.

We endeavor to provide the best service and support and to respond quickly to your questions.

Excel Made Easy is a proud sponsor of Dismantle-It.com the site that shows you the belly of your daily objects, Poupounette.com the site of cars loving cat and PowerPointMadeEasy.com the world top reference for PowerPoint Presentations questions and Pet Cemetery Online a site dedicated to your loving Pets.