Cell with "row" as the information type returns the row number of the cell
the data is in. Mod (as well as the Cell function) are explained in the Help
file. Simply click on the fx on the formula bar and type in the function and
click on the "help on this function" and a detailed explanation will be
provided. Or simply search on the function name.
Gary

"csfrolich" wrote:

Gary,

Thanks, after your correction theu both worked.
Any insight on the MOD CELL commands or direction to aid in my understanding
would be greatly appreciated.

Thanks again

cs frolich

"Gary Rowe" wrote:

oops! My second formula should read =IF(MOD(CELL("row",F5),2)=1,F5,0). Sorry.

"Gary Rowe" wrote:

Use two helper columns (column G and H for instance) and put the formula
=IF(MOD(CELL("row",F5),2)=0,F5,0) in Column G for even rows and use formula
=IF(MOD(CELL("row",F5),1)=0,F5,0) in Column H for odd rows.
Gary

"csfrolich" wrote:

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