View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stibbz Stibbz is offline
external usenet poster
 
Posts: 7
Default HELP WITH EXCEL FORMULA

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