Summing every other cell in a column?

R

RJH

A little more detail:
I'm summing about a hundred cells (every 2nd cell). Sum is limited to 30 (I
think), so I have to string together several Sums.
Is there a "cleaner" way to do this?

Thanks!

RJH
 
R

Ron Coderre

Try something like this:

For values in A1:A50

This formula adds the values in rows with odd numbers (1,3,5, etc)
B1: =SUMPRODUCT((MOD(ROW(A1:A50),2)=1)*A1:A50)

This formula adds the values in rows with even numbers (2,4,6, etc)
B1: =SUMPRODUCT((MOD(ROW(A1:A50),2)=0)*A1:A50)

Does that give you something to work with?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
B

Biff

Hi!

Assume your values are in the range A1:A10.

This will sum the values in A1, A3, A5, A7, A9:

=SUMPRODUCT(--(MOD(ROW(A1:A10),2)=1),A1:A10)

This will sum the values in A2, A4, A6, A8, A10:

=SUMPRODUCT(--(MOD(ROW(A1:A10),2)=0),A1:A10)

Biff
 
Top