=SUM

[gymwrecker]

How could I add cells like in the formula below? It's like adding every other cell...

=sum(C8,C10,C12,C14,C16,C18,C20,C22,C24,C26,C28,C30,C32,C34,C36,C38,C40,C42,C44,C46,C48,C50,C52,C54,C56,C58,C60,C62,C64,C66,C68,C70)

 

[Aladin Akyurek]

=SUMPRODUCT((MOD(ROW(C8:C70)-CELL("Row",C8:C70)+H1,H2)=0)*(C8:C70))

By your specs:

H1 = 0

H2 = 2
This message was edited by Aladin Akyurek on 2002-10-01 14:16

 

[gymwrecker]

I didn't get the H1 H2 part?

 

[Aladin Akyurek]

On 2002-10-01 14:24, gymwrecker wrote:
I didn't get the H1 H2 part?

=SUMPRODUCT((MOD(ROW(C8:C70)-CELL("Row",C8:C70)+0,2)=0)*(C8:C70))

Don't throw away +0 even though it appears superfluous.

 

[gymwrecker]

It's Working!

Thanks Aladin!!!!