GuidePedia

0
AVERAGEIF function returns the average of all cells in a range that meet given criteria.
Syntax
= AVERAGEIF (range, criteria, [average_range])
range - The range of cells that you want evaluated by criteria.
criteria - determines which cell to add.
[average_range] - This parameter is used when you want to add other than those specified in the range argument.
Examples
=AVERAGEIF(C3:C7,"male",E3:E7)
Calculate an average number of hours worked by male workers.

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