Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
total column amounts from non-contiguous rows
I'm trying to total amounts in a column from rows that are not contiguous (4
rows apart). Since there are over 100 entries, I'd rather not have to "add" each row using the simple =C1+C4+C8+C12.....etc Is there a way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
total column amounts from non-contiguous rows
=SUM(IF(MOD(ROW(C1:C100),4)=0,C1:C100))+C1
ctrl+shift+enter, not just enter Adjust your range to suit "Irving" wrote: I'm trying to total amounts in a column from rows that are not contiguous (4 rows apart). Since there are over 100 entries, I'd rather not have to "add" each row using the simple =C1+C4+C8+C12.....etc Is there a way to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
total column amounts from non-contiguous rows
Try:
=SUM(IF(MOD(ROW(C1:C100)-1,4)=0,C1:C100)) Entered with Ctrl+Shift+Enter (you will get {} round the formula). C1+C5+C9 etc NOT C1+C4 +C8 HTH "Irving" wrote: I'm trying to total amounts in a column from rows that are not contiguous (4 rows apart). Since there are over 100 entries, I'd rather not have to "add" each row using the simple =C1+C4+C8+C12.....etc Is there a way to do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
total column amounts from non-contiguous rows
Your choice of which rows to total is unclear, since your example is:
1, 4, 8, 12, ...etc. BUT you mention <<< 4 rows apart . Here are some *regular* entry suggestions, *no* CSE required: 1, 5, 9, 13 ... etc. =SUMPRODUCT((MOD(ROW(C1:C100),4)=1)*(C1:C100)) 4, 8, 12, 16 ...etc. =SUMPRODUCT((MOD(ROW(C1:C100),4)=0)*(C1:C100)) AND - your *uneven* example, 1, 4, 8, 12 ... etc. =C1+SUMPRODUCT((MOD(ROW(C1:C100),4)=0)*(C1:C100)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Irving" wrote in message ... I'm trying to total amounts in a column from rows that are not contiguous (4 rows apart). Since there are over 100 entries, I'd rather not have to "add" each row using the simple =C1+C4+C8+C12.....etc Is there a way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to total the amounts between certain dates | Excel Discussion (Misc queries) | |||
only total cells with $ amounts | Excel Discussion (Misc queries) | |||
how to total amounts in one colum | Excel Worksheet Functions | |||
Is it possible to get a sub-total of amounts when... | Excel Discussion (Misc queries) | |||
Linking total amounts | Excel Worksheet Functions |