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