Summing every other cell in a column?
 

Is there a way to do this with out using VBA?

Thanks!

RJH

Summing every other cell in a column?
 

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

"RJH" wrote in message
...
Is there a way to do this with out using VBA?

Thanks!

RJH

Summing every other cell in a column?
 

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


"RJH" wrote:

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

"RJH" wrote in message
...
Is there a way to do this with out using VBA?

Thanks!

RJH

Summing every other cell in a column?
 

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

"RJH" wrote in message
...
Is there a way to do this with out using VBA?

Thanks!

RJH

Summing every other cell in a column?
 

You hit it on the head!
That will work just fine.

Thanks!

RJH


"Ron Coderre" wrote in message
...
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


"RJH" wrote:

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

"RJH" wrote in message
...
Is there a way to do this with out using VBA?

Thanks!

RJH