Adding Data and a Running Average

  • Thread starter Thread starter aujames
  • Start date Start date
A

aujames

I have a spreadsheet that I add four columns of data to daily. I also
have four corresponding columns that calculates averages for each cell
in each column.

Is it possible to insert my four columns each day and somehow have the
cells that contain the average formula automatically update to account
for the new data?

Thanks,
JD
 
Assuming your headers in A2:D2 are repeated in E2:H2, I2:L2 and evry other block
of 4 columns that have data in, and that you do NOT have headings in Columns
that have no data, and that your values are in Row 3 down:-

In cell A3 put the following formula:-

=AVERAGE(IF($E$2:$IV$2=A$2,$E3:$IV3))

and array enter it using CTRL+SHIFT+ENTER

Now copy cell A3 and paste to B3:D3

Now copy A3:D3 and paste down
 
Back
Top