formula to count alternative Column

[OceanPlanet13X]

Does anyone know of formula to add up alternative column value- a1, c1, e2, g2 (instead of using sum(a1+c1+e2+g2)

 

[Oaktree]

Welcome to the board.

Try:

=SUMPRODUCT(--(MOD(COLUMN(A1:G1),2)=1),A1:G1)

Edit: this would sum A1, C1, E1, and G1... there isn't really a pattern for A1, C1, E2, G2...

 

[OceanPlanet13X]

thanks - this will save me lot of time

 

[Aladin Akyurek]

thanks - this will save me lot of time

In a robust form...

=SUMPRODUCT(--(MOD(COLUMN(A1:G1)-COLUMN(A1),2)=0),A1:G1)