If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
date f(x)
=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? |
#3
|
|||
|
|||
date f(x)
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? |
Thread Tools | |
Display Modes | |
|
|