Simple Average ?


J

John

I have Balances listed in columns b c d etc. In cell A1 it gives me the
average of all B1, C1 D1 etc. In A2 it gives me the averages of all b2, c2,d2
etc, and this continues down.

Each morning I enter the days' averages. So today, I want averages b1, c1,
d1. Tomorrow I will enter a new colum, so I will then want the averages b1,
c1, d1, e1. How can the equiation in A1 stay the same each time i enter a
column.
 
Ad

Advertisements

F

Fred Smith

Average will ignore blank cells. So use something like:
=average(b1:az1)
and copy down

Regards,
Fred.
 
J

John

I did think about that, but each time I add a colum (I'm adding it in culmn
B) it moves the average over. So if it currently reads =average(B1:D1) and I
add a culmn in B, it goes =average (C1:E1) when I want it to read =average
(B1:E1)

I need to add the columns in B because I need the most recent Information up
front.
 
Ad

Advertisements

F

Fred Smith

Try it this way:
=average(indirect("b1:az1"))

Then the addresses won't change.

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top