Summing Every Other Row

[hzrdc2]

I have this formula, basically selecting every other row. (I know, ugly, brute force)

=SUM(C4,C6,C8,C10,C12,C14,C16,C18,C20,C22,C24,C26,C28,C30,C32,C34)


I tried to do this, but I get #VALUE!... which looking into it is from a formatting issue, although they are all numbers I am trying to sum.

=SUMPRODUCT((MOD(ROW(C3:C34),3)=0)*(C3:C34))



WHat is the simplest way to sim every other row?

[Fluff13]

How about

Please Login or Register  to view this content.

[hzrdc2]

That did the trick! Thank you. Now I have to understand --

[Fluff13]

Glad to help & thanks for the feedback.