Excel Formula

[popeeye]

Hello All
I have a table like such below and I am using the following formula =SUM(SUM(D17)-SUMIFS(E5:E22,A5:A22,A17,B5:B22,B17-N4)) to return the result. For this example I should return a -0.05 (0-0.05)
N4 = 25
I hope I can explain this clearly
If the value in the cell = Column D ie 0 or another number OR if the value in the cell = Column E ie 0.05 or another number I want to show the value that the formula returns ="".

[TABLE="width: 384"]
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"][TABLE="width: 384"]
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Mar[/TD]
[TD="class: xl65, width: 64, align: right"]550[/TD]
[TD="class: xl65, width: 64, align: right"]0[/TD]
[TD="class: xl65, width: 64, align: right"]0[/TD]
[TD="class: xl65, width: 64, align: right"]0.05[/TD]
[TD="class: xl65, width: 64, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]Mar[/TD]
[TD="class: xl65, align: right"]600[/TD]
[TD="class: xl65, align: right"]0.1[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]0.05[/TD]
[TD="class: xl65, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]Mar[/TD]
[TD="class: xl65, align: right"]650[/TD]
[TD="class: xl65, align: right"]0.05[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]0.05[/TD]
[TD="class: xl65, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]Mar[/TD]
[TD="class: xl65, align: right"]700[/TD]
[TD="class: xl65, align: right"]0.15[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl66, align: right"]0.05[/TD]
[TD="class: xl65, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]Mar[/TD]
[TD="class: xl65, align: right"]725[/TD]
[TD="class: xl65, align: right"]0.1[/TD]
[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl65, align: right"]0.05[/TD]
[TD="class: xl65, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]Mar[/TD]
[TD="class: xl65, align: right"]750[/TD]
[TD="class: xl65, align: right"]0.05[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]0.05[/TD]
[TD="class: xl65, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]Mar[/TD]
[TD="class: xl65, align: right"]775[/TD]
[TD="class: xl65, align: right"]0.1[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]0.05[/TD]
[TD="class: xl65, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]Mar[/TD]
[TD="class: xl65, align: right"]800[/TD]
[TD="class: xl65, align: right"]0.1[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]0.05[/TD]
[TD="class: xl65, align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="class: xl63, width: 64, align: right"][/TD]
[TD="class: xl63, width: 64, align: right"][/TD]
[TD="class: xl63, width: 64, align: right"][/TD]
[TD="class: xl63, width: 64, align: right"][/TD]
[TD="class: xl63, width: 64, align: right"][/TD]
[/TR]
</tbody>[/TABLE]


Thanks
Craig

 

[popeeye]

sorry just like to clarify in this example I return -0.05 when I would like to return either a blank cell or 0