Hi
do you mean
=SUMPRODUCT(--(MOD(ROW(A6:A17),2)=1),A6:A17)

--
Regards
Frank Kabel
Frankfurt, Germany

"Aaron Neunz" schrieb im Newsbeitrag
...
I have a range of Cells:
A6:A17
The even numbered cells will always have some text in them.
The odd numbered cells may or may not have any values.
IF(ISBLANK("ALL ODD NUMBERED CELLS IN RANGE"),BLANK,(SOME CALCULATION
IF
FALSE)

How would the syntax in ""'s in the above formula look?

Thanks in advance,
Aaron Neunz