I have a column for a simple running balance. I have used the formula that
sez if 0... so that if nothing is in the cell, then the running balance will
be blank; I don't want zeros,or the last accurate balance to be populated
down the column. So here's the formula I've been using:
=IF(H3 0,SUM(I2+H3)," ")
But What I really want is if it is blank. Because now I'd like to add
negative numbers in Column I; but then the formula above won't work. I've
tried if H3" ", but that returns an error. So, my question is - how do you
write a clean formula to sum only if Column I contains a value? Thanks for
any help.