Simple Average ?
 

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.

Simple Average ?
 

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

Regards,
Fred.

"John" wrote in message
...
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.

Simple Average ?
 

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.

"Fred Smith" wrote:

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

Regards,
Fred.

"John" wrote in message
...
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.

Simple Average ?
 

John;217479 Wrote:
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.

"Fred Smith" wrote:

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

Regards,
Fred.

"John" wrote in message
...
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.



Try as follows :
Insert - Name - define - Enter a name - as formula enter
=offset($b$1,0,0,1,counta(1:1)) - OK
now wherever you like enter =average(the_name _you_have_chosen)


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59748

Simple Average ?
 

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

Then the addresses won't change.

Regards,
Fred.

"John" wrote in message
...
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.

"Fred Smith" wrote:

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

Regards,
Fred.

"John" wrote in message
...
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.

Simple Average ?
 

Fred Smith;217874 Wrote:
Try it this way:
=average(indirect("b1:az1"))

Then the addresses won't change.

Regards,
Fred.

"John" wrote in message
...
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.

"Fred Smith" wrote:

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

Regards,
Fred.

"John" wrote in message
...
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.



As long as there is no 0 value lost somewhere on the way...


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59748