Trying to do a calculation off null SumIfs

[cjmueller08]

Hello, have a basic some basic sumifs values I'm trying to return a value on and cannot get it to recognize the blanks or "-" returns from the sumifs. Example below. The Over/Under column should be mainly "No Payment" but I cannot get excel to recognize the "-" returns from the sumif formulas. Thanks in advance for any help!


Claimed Column Formula: =SUMIFS('PER75'!G:G,'PER75'!C:C,'Warranty Recover Template'!A5,'PER75'!G:G,">0")
Recovered Column Formula: =SUMIFS('PER75'!G:G,'PER75'!C:C,'Warranty Recover Template'!A5,'PER75'!G:G,"<0")

Over/Under Column Formula: =IF(C5="","No Payment",C5+B5) I've tried several scenarios but can't get this formula to recognize the blank or "-" cells.

Repair Order / Control #	Claimed	Recovered	Over/Under	Manufacturer
RO #				Make
40000A	$ 310.07	$ -	$ 310.07	LEE
40001A	$ 310.07	$ (310.07)	$ -	LEE
40002A	$ (310.07)	$ -	$ (310.07)	LEE
40027A	$ 1,649.32	$ -	$ 1,649.32	LEE
40060A	$ 521.70	$ -	$ 521.70	LEE
40077A	$ 5,285.66	$ -	$ 5,285.66	DYN
40082A	$ 1,483.55	$ -	$ 1,483.55	DYN
40109A	$ 687.50	$ -	$ 687.50	ROS
40110A	$ 701.62	$ -	$ 701.62	DYN

 

[Cubist]

Try:

=IF(ISNUMBER(C5), C5+B5,"No Payment")

 

[james_martin001]

With the table set with currency formatting, cell values should still be zero, even if it shows a dash, the dash is probably not recognisable in formulas:

=IF(C5=0,"No Payment",B5+C5)