COUNTIFS() MS EXCEL Stats Function

Join instructors who have made over $338m in sales

Function used in Microsoft Excel


This function is used mainly in excel for statistic purpose.

Syntax of the Function: COUNTIFS( Criteria_range-1, Criteria-1, Criteria_range-2, Criteria-2, …)

You get how much for free at WPX

Criteria_range: the group of cells the function is to search.
Criteria: determines whether the cell is to be counted or not.
Note: Around 127 range/criteria pairs can be entered into the function.

The ranges must be be identical and the function will return only instance where the criteria is met the range.

Column E has numbers from E3 to E8
Objective: To identify the count of record within 50 to 100
Formula: =COUNTIFS(E3:E9,”>50″,E3:E9,”<100″)

This can also be used more in taking statistical data for monthly or year report.


Get Your Hosting Now At Bluehost


SurFolks, the one stop destination to cater all your wants and needs.

You May Also Like

8 Things To Know When Creating Video For Youtube


What are the Basic Preventive Measures that You Can Take?

Print Your Expressions and Connect Customers in Day to Day Life

Top 10 Reason to Host Your Website in Bluehost

Leave a Reply