For odd rows, starting at F5 down to F957, try this:

=SUMPRODUCT((MOD(ROW(F5:F957)-5,2)=0)*(F5:F957))

For even rows, starting at F6 down to F958, try this:

=SUMPRODUCT((MOD(ROW(F6:F958)-6,2)=0)*(F6:F958))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"csfrolich" wrote in message
...
I am attempting to add every other cell in a 958 row set of numbers.

For instance: =SUM (F5+F7+F9+F11+F13......F957) and then I want to add all
the even number rows, =SUM (F6+F8+F10+F12+F14......F958).

Any suggestions other than typing this formula out.

Thanks