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

Assuming you meant (A181:A360) for the second average, put this in B1 and copy
down as needed:

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