+ Reply to Thread
Results 1 to 5 of 5

Need a Formula to Add a Row of Numbers and Then Subtract if from Another Cell Amount

  1. #1
    Registered User
    Join Date
    12-02-2013
    Location
    Berkeley
    MS-Off Ver
    Excel 2007
    Posts
    2

    Need a Formula to Add a Row of Numbers and Then Subtract if from Another Cell Amount

    I have a row A through N. In cell A1, have a dollar amount. In cells C1 through N1, I have different dollar amounts. In cell O1, I want to have a formula that will take the dollar figure in A1 and subtract from that amount the total of all the amounts in cells C1 thorugh N1. But I don't know how to write that formula.

    Let's say I've got $100 in A1, and then in C1 through N1, I have $2, $3, $4, etc. for a total amount of $94 in cells C1 through N1. I'd like to have a formula in O1 that would show $6.

    I hope this is clear. I'd appreciate any help about how to write up that formula in cell O1.

    Jason

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Need a Formula to Add a Row of Numbers and Then Subtract if from Another Cell Amount

    Try this.....

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Need a Formula to Add a Row of Numbers and Then Subtract if from Another Cell Amount

    In O1 Cell

    =A1-SUM(C1:N1)


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Registered User
    Join Date
    12-02-2013
    Location
    Berkeley
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Need a Formula to Add a Row of Numbers and Then Subtract if from Another Cell Amount

    Perfect! Thanks very much for such a quick response.

    Jason

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Need a Formula to Add a Row of Numbers and Then Subtract if from Another Cell Amount

    Glad it helps you and thanks for the feedback

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Subtract Range Of Numbers using a Formula
    By Josh Davis in forum Excel General
    Replies: 2
    Last Post: 06-25-2014, 10:22 AM
  2. [SOLVED] add or subtract numbers in one cell dependig which numbers in another cell
    By SMasher in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-07-2013, 07:26 AM
  3. Formula to subtract overage if total is more than a set amount
    By simble23 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-29-2012, 12:44 AM
  4. Formula for amount owing subtract amount paid
    By Taperchart in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2006, 12:55 PM
  5. Need to subtract vat from gross amount.
    By buachille in forum Excel General
    Replies: 2
    Last Post: 09-22-2005, 01:43 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1