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?

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?

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?

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?