+ Reply to Thread
Results 1 to 2 of 2

How to write formula for subtracting multiple cells from different columns and rows

Hybrid View

  1. #1
    Registered User
    Join Date
    10-23-2012
    Location
    new jersey
    MS-Off Ver
    Excel 2003
    Posts
    2

    How to write formula for subtracting multiple cells from different columns and rows

    Hi,

    I am having trouble with a formula. This is an example of what I am trying to accomplish:

    I have a beginning balance in A1 and want to subtract B2, C3 and D4 and have an ending balance in G20.

    Any assistance that can be offered would be appreciated.

    Thanks,

    Marc
    Last edited by Marc1320; 10-23-2012 at 10:31 AM.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: How to write formula for subtracting multiple cells from different columns and rows

    Hi Marc,

    Does this work for you?

    =A1-(SUM(B2,C3,D4))
    HTH
    Regards, Jeff

+ 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