Subtract if formula

Hi Everyone!

I need your help please. I have 6,900,000 budget. I need to compute for (budget less cost). Do we have formula that can compute the amount, only if I provided the date. The B4 (33000) will subtract to B1 (6,900,000) only if I put a date on supposedly C4?

Please help with the formula. Thanks in advance!

A1:Budget B1:6,900,000

Add a row under row 1 and label it Budget Remaining (A2) in B2 enter
=B1-IF(C4<>"",B4)-IF(C5<>"",B5)

Quick and dirty but depending on how many budget items you have it would work. You can add other budget items and add to your formula. I'm sure there are fancier ways - provided this is what you're looking for.

This is superb! Thank you DSDressler, super BIG help to me

Single formula

=$B$1-SUMIF($C$2:$C$20,"<>",$B$2:$B$20)