Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel column headers read right to left | Excel Discussion (Misc queries) | |||
Column labels run right to left, not left to right | Excel Discussion (Misc queries) | |||
excel column & row numbers displaying right to left? | Excel Discussion (Misc queries) | |||
Right column doesn't change when sorting left column. | Excel Discussion (Misc queries) | |||
How to hide the column headings displayed by Excel at the left of. | Excel Discussion (Misc queries) |