Problem with Sumif, and blank cells

Originally Posted by sweep

Hi,

Cell C2 isn't blank, it has a space in it.

If the space has to stay, you could use something like this in column D

=IF(B2="Check",IF(ISTEXT(C2),A2,A2-C2),"")

Otherwise, remove the space in C2, and use

=IF(B2="Check",A2-C2,"")

First formula works great - Thank you