Find Average of SUMIF

**Jogier505** · 10-12-2010, 04:45 PM

Using the formula

Please Login or Register  to view this content.

I get the sum of column "I". TM Log "B" is a month value formated as Oct, Column "I" is a number value and Cell C5 is a date (Oct).

I want to average the values in column "I" according to the month selected in cell C5. My limited knoweldege of Excel has left me in the dark as to a solution.

Jim O

**peterjuhnke** · 10-12-2010, 05:32 PM

Try
=SUMIF('TM Log'!$B:$B,($C5),'TM Log'!$I:$I) / count(TM Log'!$I:$I)
Latter versions have average function.
Regards
Peter

**DonkeyOte** · 10-12-2010, 05:59 PM

Peter, did you perhaps mean to use COUNTIF (based on month) as Divisor rather than COUNT of all numbers ?

**peterjuhnke** · 10-13-2010, 08:10 AM

cheers D'O'
yes thats what I was meant to of chucked in.
=SUMIF('TM Log'!$B:$B,($C5),'TM Log'!$I:$I) / countif ('TM Log'!$B:$B,$C5)
thanks for the pickup.
Regards
Peter