+ Reply to Thread
Results 1 to 4 of 4

Subtract multiple cells from one cell

  1. #1
    Registered User
    Join Date
    08-03-2021
    Location
    Scotland, United Kingdom
    MS-Off Ver
    Office 365
    Posts
    2

    Subtract multiple cells from one cell

    Hi,

    Hope you guys can help.

    I am trying to subtract a selection of cells in a column from one cell in a different column.

    Yet when I try it is coming up with a ridiculous number.

    I have uploaded it as a file attachment to this post (SECOND TAB in EXCEL). Both as an image (better explaining/showing the problem) and as the excel spreadsheet as well, thanks.


    Kind regards,

    Nick Peyton
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by nrpeyton; 08-03-2021 at 03:01 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Subtract multiple cells from one cell

    I think this is what you're trying to do:
    Please Login or Register  to view this content.
    What you had was
    Please Login or Register  to view this content.
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

  3. #3
    Registered User
    Join Date
    08-03-2021
    Location
    Scotland, United Kingdom
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Subtract multiple cells from one cell

    Quote Originally Posted by jomili View Post
    I think this is what you're trying to do:
    Please Login or Register  to view this content.
    What you had was
    Please Login or Register  to view this content.
    awww, that is excellent. Looks like such a quick fix too! But I would never have got it myself.

    You are fantastic... thank you! I wasted 3hrs on this and I have a University assessment. (Thanks so much -- life saver)!!

    Go jomili!!!!!!!!! thank you.!!

  4. #4
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Subtract multiple cells from one cell

    Hey Nrpetyon, if that solved your problem will you close the thread by marking it SOLVED (you'll find that under THREAD TOOLS).

+ 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 one number from multiple cells and output into several cells
    By TheOddSwede in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-15-2019, 10:54 AM
  2. If cell contains value, subtract from multiple cells
    By PreppieCrown in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-07-2019, 02:33 PM
  3. [SOLVED] Use current value and subtract from multiple cells
    By EspenKalland in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2018, 12:11 PM
  4. How to subtract multiple cells from a signle value
    By JustBringIt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2016, 10:29 AM
  5. Is there a shortcut key that will subtract multiple cells?
    By cmorten82 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-29-2015, 03:00 AM
  6. New to Excel and need help with subtract multiple cells for one cell
    By rpbrown88 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-13-2013, 08:56 PM
  7. [SOLVED] How to subtract multiple cells from a cell and report soldout when main number reaches 0
    By QuietForce in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-02-2012, 01:43 AM

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