Problem with Sumif, and blank cells

[Chirayu Amin]

Hi All

I need help with below please,

I am trying to do sumif on below

A B C Total that I need to achieve
-520 Check [blank] -520
-321 Check -321 0


Criteria
Sumif B2 have "Check" add A2 then -C2 Problem is C2 although shows no value, there is formula that returns Blank Value.

Please see attached file.

Thank you for your help

Chirayu

[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,"")

[Chirayu Amin]

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