Excel 2007 : Average calculation with two criterias

**SorZer** · 01-22-2011, 03:45 PM

I am trying to make a calculation that's checks for a given month then for a given day and then adds it up a average?. been messing with this but cant solve it myself.. Ps. don't want a pivot table for this. If i use numbers like 1.2.3.4 instead of dates i have got it work with AVERAGEIFS. But every time a change back to dates it becomes 0
Help me :-(

**daddylonglegs** · 01-22-2011, 03:56 PM

For AVERAGEIFS to work you need a start and end date rather than a month, e.g. if you change G3 to a date, 1st of the relevant month, you can use this formula

=AVERAGEIFS(C2:C17,B2:B17,G4,A2:A17,">="&G3,A2:A17,"<="&EOMONTH(G3,0))

**SorZer** · 01-26-2011, 05:43 AM

Originally Posted by daddylonglegs

For AVERAGEIFS to work you need a start and end date rather than a month, e.g. if you change G3 to a date, 1st of the relevant month, you can use this formula

=AVERAGEIFS(C2:C17,B2:B17,G4,A2:A17,">="&G3,A2:A17,"<="&EOMONTH(G3,0))

Thanks allot. That just saved my work... Your the man of my day ;-)