Results 1 to 4 of 4

Thread: Subtract if formula

  1. #1

    Subtract if formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

    A2: Course B2:Cost C2: Date
    A3: Social B3: 5000 C3: 10-Mar-15
    A4:Gathering B4: 33000

  2. #2
    Seeker DSDressler's Avatar
    Join Date
    Dec 2014
    Location
    Bend, OR
    Posts
    18
    Articles
    0
    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.

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

  4. #4
    Single formula

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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •