Hi - I'm trying to add every other cell in a column. I've used code like this before to add every other row:
{=SUM(B2:B6*(MOD(ROW(B2:B6),2)=1))}
However, the cells in column B that I'm adding have a formula that will set the cell value to the empty string:
=IF(A2="","",A2+1)
If one of the cells being added is empty, I get the error: #VALUE!.
I thought empty cells would be interpreted as zeros. I've looked around online, but not found a solution. Attached is a sample of the problem. Does anyone have any ideas? BTW, this is a simplification of the formula--I'm not just adding 1 to the value in column A in my real spreadsheet--but this shows the problem.
Bookmarks