Hi!

Assume your values are in the range A1:A10.

This will sum the values in A1, A3, A5, A7, A9:

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

This will sum the values in A2, A4, A6, A8, A10:

=SUMPRODUCT(--(MOD(ROW(A1:A10),2)=0),A1:A10)

Biff

"RJH" wrote in message
...
Is there a way to do this with out using VBA?

Thanks!

RJH