HELP WITH EXCEL FORMULA
Hi,
You can do it with a number of formulas:
=AVERAGE(INDIRECT("C"&12*ROW()-11&":C"&12*ROW()))
=AVERAGE(OFFSET(C$1,12*ROW()-12,,12))
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"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
|