Sum of Every Other cell

[That's Confidential]

If I want to work out the sum of every other cell in a column, say for
example, A1+A3+A5+A7 etc......., how would I go about doing it? Is there a
quicker way than actually just using the + sign?

 

[Aladin Akyurek]

=SUMPRODUCT(--(MOD(ROW($A$1:$A$100)-CELL("Row",$A$1)+0,2)=0),$A$1:$A$100)

 

[Bob Phillips]

Try this

=SUMPRODUCT((A1:A10)*(MOD(ROW(A1:A10),2)=1))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)