On Sat, 14 Feb 2009 06:26:01 -0800, Stibbz
wrote:

I need to calculate the average temperature of every year and I know the
formula is '=AVERAGE(C2:C13)' but how would I replicate this so I don't have
to type it into every cell to work it out. As the next one would be
'AVERAGE(C14:C25)

Any help would be greatly appreciated!

Thanks in advance
Sam


Where do you want your averages to be placed on the worksheet?

Lars-Åke