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

Thanks!

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

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

Thanks!

RJH

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

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

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