I'm assuming you want an average of 180 cells all the time (your second array
of 181:361 is actually 181 cells)

=AVERAGE(INDIRECT("A"&(ROW(A1)-1)*180+1&":A"&ROW(A1)*180))

As you copy this down, it will average 1:180, 181:360, 361:540, etc.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"tiggs96" wrote:

We have an excel spreadsheet with constant data entered. We are trying to
formulate a constant average of these points and having no luck. Is there a
way to set up a formula that will consistantly average points? An example of
what we are looking for would be averaging (A1:A180) and then the next
average would be (A181:A361). Can somebody help me figure out how to make
this a consistant formula without having to constantly put in the next round
of cells?
Lori

thanks for all your help that works just the way we needed it to. I really
appreciated all your help.

"Luke M" wrote:

I'm assuming you want an average of 180 cells all the time (your second array
of 181:361 is actually 181 cells)

=AVERAGE(INDIRECT("A"&(ROW(A1)-1)*180+1&":A"&ROW(A1)*180))

As you copy this down, it will average 1:180, 181:360, 361:540, etc.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"tiggs96" wrote:

We have an excel spreadsheet with constant data entered. We are trying to
formulate a constant average of these points and having no luck. Is there a
way to set up a formula that will consistantly average points? An example of
what we are looking for would be averaging (A1:A180) and then the next
average would be (A181:A361). Can somebody help me figure out how to make
this a consistant formula without having to constantly put in the next round
of cells?
Lori