Prev: Pull info from one excel file to another depending on values of O.
Next: Possible to have various sections of worksheets print on 1 page?
From: FunChickyPoo on 28 Apr 2010 13:53
I have used the following formula and it works perfectly, however, one column
is % and I want to get an average of the %'s with the same criteria. Can
this be done?

Basically, is there and AVERAGEIFS function?

=SUMIFS(AT$4:AT$169,$G$4:$G$169,$G174,$F$4:$F$169,$F174,$J$4:$J$169,"<=12/31/10",$J$4:$J$169,">=01/01/10")
 | 
Pages: 1
Prev: Pull info from one excel file to another depending on values of O.
Next: Possible to have various sections of worksheets print on 1 page?