I have been using the following SUMIFS funtion that works perfectly, but need
to average a column of %. Is ther esucha thing as AVERAGEIFS that will work
with multiple criteria?

=SUMIFS(AF$4:AF$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")

AVERAGEIFS should work. You may want to format your dates differently.
Instead of "<=12/31/2009", try "<="&DATE(2009,12,31).
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"FunChickyPoo" wrote:

I have been using the following SUMIFS funtion that works perfectly, but need
to average a column of %. Is ther esucha thing as AVERAGEIFS that will work
with multiple criteria?

=SUMIFS(AF$4:AF$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")