+ Reply to Thread
Results 1 to 2 of 2

How do I subtract a mass of numbers from a number?

  1. #1
    Registered User
    Join Date
    12-03-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    54

    How do I subtract a mass of numbers from a number?

    Probably a super simple one but I'm stuck


    A1 245
    A2
    A3 8
    A4 7
    A5 90
    A6 15
    A7 67
    A8 13

    A1 being the Total
    A2 I want to be the difference whether it be plus or minus, of A1 minused A3-A8,
    in this case 45 is the answer

    Thanks!

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: How do I subtract a mass of numbers from a number?

    Hi Sponge,

    Perhaps try:

    =A1-SUM(A3:A8)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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