COUNTIFS() MS EXCEL Stats Function

Disclosure: We sometimes use affiliate links in our content. This won’t cost you anything but it helps us to offset our operative costs. Thanks for your support!

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, …)

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 it done on Fiverr


Related Post
You get how much for free at WPX
Also Read  Print Your Expressions and Connect Customers in Day to Day Life
Leave a Reply

Your email address will not be published.