COUNTIFS() MS EXCEL Stats Function

  • Facebook
  • Twitter
  • Delicious
  • StumbleUpon
  • Pinterest
  • Google Plus

COUNTIFS()
Function used in Microsoft Excel

COUNTIFS()
COUNTIFS()

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.

Sample:
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.

 

Like(0)Dislike(0)

Share and Enjoy

prabaharancs@gmail.com'

SurFolks

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

Leave a Reply