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