+ Reply to Thread
Results 1 to 2 of 2

subtract multiple cells if conditions are met

Hybrid View

  1. #1
    Registered User
    Join Date
    02-26-2019
    Location
    Oh,US
    MS-Off Ver
    2019
    Posts
    1

    subtract multiple cells if conditions are met

    I am trying to figure out how to make it so if column A on sheet 1 matches column A on sheets 2 and 3 it subtracts the number in column G on sheets 2 and 3 from Column B on sheet 1. I am not very well versed in excel but what i came up with is
    Formula: copy to clipboard
    =B2-VLOOKUP(A2,Mercari!A3:H2000,7,FALSE)-VLOOKUP(A2,Ebay!A3:H2000,7,FALSE)
    . This works but only finds the first value on each page and the data in column A appears more than once on each page. any help would be appreciated

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,826

    Re: subtract multiple cells if conditions are met

    Try:
    Formula: copy to clipboard
    =B2-SUMIFS(Mercari!A3:A2000,A2,Mercari!H3:H2000)-SUMIFS(Ebay!A3:A2000,A2,Ebay!H3:H2000)
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. [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
  2. 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
  3. 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
  4. 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
  5. [SOLVED] Subtract Dates & Times From Multiple Cells To Get Duration
    By sshot1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2012, 10:34 AM
  6. Subtract cells from each other IF certain conditions are met.
    By Krypt0n1te in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2011, 06:42 PM
  7. [SOLVED] Add and Subtract ranges (with multiple cells) in vba
    By Jon5001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2005, 02:06 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