It's kind of academic now since you seem happy with the SUMPRODUCT solution,
but just to close the loop.......

Assume column G as your helper column in which you put the "odd" and "even"
notations.........then the formula could be modified as follows to fit your
range:

=SUMIF(G6:G922,"odd",F6:F922)

Vaya con Dios,
Chuck, CABGx3


"csfrolich" wrote in message
...
CLR,

I tried your formula, and quickly learn that the B:B function designated
column B.
I did try to change the B's ... to F's .
Since I was working in column F. I do not understand the A:A. I do
understand changing the odd to even. My array is F6 down to F922. If your
formula could relate to this array, I may get it a bit more.

Thanks

cs frolich

"CLR" wrote:

I would use a helper column and put "odd" or "even" respectively in each
row..........this can be copied down very quickly..........

Then use something like =SUMIF(B:B,"odd",A:A)

Vaya con Dios,
Chuck, CABGx3


"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