sum of every forth column to left excel
 

I have designed a cashflow forcast and need to be able to extend it easily.
for each month I have 4 columns and one is a the cumlative of another of the
4 columns in all proceeding month. I am tryong to find a way of easily
extending this by filling across. the problem is it needs to add evey say
forth column on the left and as you fill across it needs to extend the
formula. This formula is only in every forth column itself ie there are other
formulas between itself and its repeats. I can fill across but my problem is
getting it to automatically extend.If I do it manually it takes ages. Any
help would be appreciated

sum of every forth column to left excel
 

Robin,

Something like this, array entered (entered using Ctrl-Shift-Enter)

(this formula in cell L1)
=SUM(IF(MOD(COLUMN($A$1:K1),4)=0,$A$1:K1,0))

HTH,
Bernie
MS Excel MVP



"Robin" wrote in message
...
I have designed a cashflow forcast and need to be able to extend it easily.
for each month I have 4 columns and one is a the cumlative of another of
the
4 columns in all proceeding month. I am tryong to find a way of easily
extending this by filling across. the problem is it needs to add evey say
forth column on the left and as you fill across it needs to extend the
formula. This formula is only in every forth column itself ie there are
other
formulas between itself and its repeats. I can fill across but my problem
is
getting it to automatically extend.If I do it manually it takes ages. Any
help would be appreciated

sum of every forth column to left excel
 

Hi,

Why don't you show us the formula you are currently using and a sample of
what you want it to look like after you copy it.

Normally, I would say change references like A1:H1 to $A1:H1, but I really
should see what you have.

--
Thanks,
Shane Devenshire


"Bernie Deitrick" wrote:

Robin,

Something like this, array entered (entered using Ctrl-Shift-Enter)

(this formula in cell L1)
=SUM(IF(MOD(COLUMN($A$1:K1),4)=0,$A$1:K1,0))

HTH,
Bernie
MS Excel MVP



"Robin" wrote in message
...
I have designed a cashflow forcast and need to be able to extend it easily.
for each month I have 4 columns and one is a the cumlative of another of
the
4 columns in all proceeding month. I am tryong to find a way of easily
extending this by filling across. the problem is it needs to add evey say
forth column on the left and as you fill across it needs to extend the
formula. This formula is only in every forth column itself ie there are
other
formulas between itself and its repeats. I can fill across but my problem
is
getting it to automatically extend.If I do it manually it takes ages. Any
help would be appreciated