I'll bet that's a great solution but it's like a PHD coaching a
kindergardener. Many thanks anyway. KRM

"Aladin Akyurek" wrote:

KRM wrote:
how may I devise a formula for adding only alternate cells in columns?

=SUMPRODUCT(--(MOD(ROW(A3:A8)-ROW($A$3)+0,2)=0),A3:A8)

Replace the +0 bit with +1 if summing must start with the first 2nd value.

Note that 2 (the Nth row parameter) can be any admissible value, odd or
even.