+ Reply to Thread
Results 1 to 2 of 2

How to subract from a grand total

  1. #1
    Registered User
    Join Date
    07-26-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    How to subract from a grand total

    Hi there,
    im looking for the formula that will enable me to subract from a grand total. So for example if I have a total in B1 and then I enter a number into b2, B3, B4 etc what would the sum be for these values to deduct from the total.

    Hope this makes sense

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: How to subract from a grand total

    If cell B1 holds the value for grand total, then in an empty cell this formula:

    =B1-(SUM(B2:Bnnn))
    where nnn = the last row of cells in the column to sum, i.e. B10, etc.

+ 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