Results 1 to 11 of 11

Subtract value if value matches that of another cell

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2022
    Location
    KY
    MS-Off Ver
    Office 360
    Posts
    3

    Subtract value if value matches that of another cell

    Hello all, and thanks ahead of time for any help you are able to provide. New to what I would consider more complicated Excel formulas, so I'll try not to confuse with my request!

    In the attachment, I'd like to populate column N on the September 2022 sheet with something like =M2-'August 2022'!M2 but only if the value in column B matches. The problem is, I need to do this month over month and the values in column B will not always abe in the same order. I believe it will need to match via VLOOKUP?? I hope this makes sense, please ask clarifying questions as needed.

    Thank you!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 09-09-2021, 05:08 PM
  2. Subtract until 0 then move to next cell to subtract until 0
    By manateee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-15-2020, 03:32 AM
  3. [SOLVED] take the sum of cell D40, subtract it with cell D39, then spread evenly across cell range
    By JRP Excel Guy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-23-2019, 01:28 PM
  4. [SOLVED] If date matches and room matches, return room info in to cell
    By HonorBray in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-12-2018, 12:09 PM
  5. [SOLVED] If Account column value matches, add/subtract to a cell value
    By shivers in forum Excel General
    Replies: 4
    Last Post: 07-19-2017, 12:42 PM
  6. Replies: 4
    Last Post: 03-14-2014, 09:54 AM
  7. Replies: 1
    Last Post: 01-27-2012, 11:25 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