Average IFS (Multiple Criteria)

F

FunChickyPoo

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

PJFry

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average IFS (Multiple Criteria) 0
Average IFS (Multiple Criteria) 1
SumIf or SumIfs or something else? 2
AVERAGESIFS Function - average cells that fall within a date rangeand meet additional criteria 3
Counting rows that meet multiple criteria 5
Counting based on multiple criteria 8
Multiple chart creation using multiple series in the same row 1
Cell Color Recognition and Summing of Data Within a Specified Colo 1

Top