count record in range in Excel
Q20. In Excel, how can I find the count of records that meet a given condition in my raw data table?
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.
b) Copy the formula as needed for the data pertaining to other quarters.