Summing every other cell in a column?

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" <[email protected]> wrote in message
news:zAh%[email protected]...
> 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" <[email protected]> wrote in message
> news:zAh%[email protected]...
> > 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" <[email protected]> wrote in message
news:zAh%[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:zAh%[email protected]...
>> > Is there a way to do this with out using VBA?
>> >
>> > Thanks!
>> >
>> > RJH
>> >
>>
>>
>>