date f(x)

I am trying to automate an average function. At the
present I am trying to average six columns. Next month
there will be new data and thus the average range will
essentially move down one column. Is there anyway of
automating this by using some sort of "column count = 6"
command?

=AVERAGE(A2:L2)

use the whole range since average will disregard blank cells

--

Regards,

Peo Sjoblom


"briank" wrote in message
...
I am trying to automate an average function. At the
present I am trying to average six columns. Next month
there will be new data and thus the average range will
essentially move down one column. Is there anyway of
automating this by using some sort of "column count = 6"
command?

How is your data laid out now, and how do you add new columns when you do it, or are all the
columns already in place, and you just add the data as and when necessary.

The AVERAGE function will ignore empty cells, so you can set it up to cover the entire range and
it will only actually count the cells with data in.

If you are adding Columns each time, then Assuming your current range was A2:F2, you could use a
formula of say =AVERAGE(A2:G2), making Col G a bit thinner and perhaps colouring it slightly.
Then when you need to add a column, simply select a cell in Col G and then do Insert / Columns.
This will automatically extend the range in your formula, and as AVERAGE ignorees empty cells
anyway, it won't matter that you are picking up an empty cell at the end of the range each time.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"briank" wrote in message ...
I am trying to automate an average function. At the
present I am trying to average six columns. Next month
there will be new data and thus the average range will
essentially move down one column. Is there anyway of
automating this by using some sort of "column count = 6"
command?