GuidePedia

0
AVERAGEIFS function returns the average of all cells in a range that meet multiple criteria.
Syntax
= AVERAGEIFS (average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
average_range - The range of cells too average.
criteria_range1, criteria_range2 - Range of cells to check the associated criteria.
criteria1, criteria2 - Criteria by which you want to filter cells.
Examples
=AVERAGEIFS(E3:E7, C3:C7,"male",D3:D7,"<60")
Calculate an average number of hours worked by male workers who are less than 60 years old.

Post a Comment

Blogger Tips and TricksLatest Tips And TricksBlogger Tricks

Visitors

Cloud Power For You

Website Hosting At Low Price

Contatc

Empire Views
 
Top