Average IFS (Multiple Criteria)
 

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")

Average IFS (Multiple Criteria)
 

SUMIFS and AVERAGEIFS use the same syntax so all you need to do is replace
SUMIFS with AVERAGIFS.

--
Biff
Microsoft Excel MVP


"FunChickyPoo" wrote in message
...
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")

Hi,
I had a similar problem in Excel 2003. I 've used array formula like this =AVERAGE(IF(($G$4:$G$169<$G174)*($F$4:$F$169<$F174 )*($J$4:$J$169<=12/31/10),AT$4:AT$169)). Example is he http://excel-example.com/other-tutor...ple-conditions

I hope it helps someone.