Articles → EXCEL FORMULA → Averageif Function In Excel

Averageif Function In Excel






Purpose





Syntax


=AVERAGEIF(Range, criteria)




  1. Range – Range of cells where average needs to be calculated.
  2. Criteria – Condition which tells whether a particular cell in the range is included in the average calculation or not.

Example




Picture showing the output of AverageIf function in excel
Click to Enlarge




Posted By  -  Karan Gupta
 
Posted On  -  Thursday, December 22, 2016

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250