Averageif Problem - Incorrect Average

[jws]

Hello,

I have a bunch of cities that I am tracking weather for and I thought I could handle this with an “averageif” statement. Basically I want to make a weekly summary by week number (1, 2, 3, etc) and have the 7 day average of the temperature for a go-forward basis. I tried the code below and for some reason my averages are not coming out correct. I have pictures of both tabs and if any other information is need please let me know.

Cities 2011

Formula in Cell D4 on tab “Cities Weekly Summary”
=AVERAGEIF('Cities 2011'!$A$3:$E$365, 'Cities Weekly Summary'!A4, 'Cities 2011'!$E$3:$E$365)

Cities Weekly Summary

 

[Marcol]

Try this in Sheet 'Cities Weekly Summary' D4

=AVERAGEIF('Cities 2011'!$A$4:$A$365, 'Cities Weekly Summary'!A4, 'Cities 2011'!$E$4:$E$365)

 

[jws]

Ahh... so simple , worked like a charm!

Thank you.