Note that in Excel 0 > [space] > =""

If somehow A1 or B1 takes on one of the second two values (a space or empty string), any formula involving >0 will not work. Just to pile on, here's my suggestion: =IF(AND(ISNUMBER(A1),ISNUMBER(B1)),SUM(A1:B1),"")