+ Reply to Thread
Results 1 to 2 of 2

Using =G8-SUMIF('MASTER SALES'!C:C,A8,'MASTER SALES'!J:J) but I forgot to include # sold

  1. #1
    Registered User
    Join Date
    01-28-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    1

    Using =G8-SUMIF('MASTER SALES'!C:C,A8,'MASTER SALES'!J:J) but I forgot to include # sold

    I'm using this function and it works but I forgot to include subtracting total # sold on "Master Sales Sheet" from the qty ordered total on "Inventory Sheet" - the answer should be reflected in the "Current Inventory Total Column"l on the "Inventory Sheet". Please help thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Using =G8-SUMIF('MASTER SALES'!C:C,A8,'MASTER SALES'!J:J) but I forgot to include # so

    Sorry Just Splurge but I don't see your problem!

    The formula you posted is giving the correct answer.

    Row 8 shows that you ordered 26. According to the MASTER SALES sheet, you sold 14. So 26-14=12 which is what you are showing.

    Am I missing the question?

    Regards,

    David


    When you reply please make it clear WHO you are responding to by mentioning their name.
    If this has been of assistance, please advise. A little thanks goes a long way.
    - Please click on the *Add Reputation button at the bottom of helpful responses.
    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".

+ 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. Replies: 6
    Last Post: 10-19-2013, 04:53 PM
  2. [SOLVED] Weekly Sales moved to Master, if match conditions replace existing other wise new line
    By gwsampso in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-16-2013, 07:18 AM
  3. [SOLVED] Sales order form from a master product list
    By dawondr in forum Excel General
    Replies: 3
    Last Post: 05-04-2013, 08:42 AM
  4. pushing data from master monthly sales sheet to debtors list
    By Toddsleap in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-22-2012, 09:56 AM
  5. Help required updating Master worksheet from a sales Worksheet
    By tgracey in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 04-03-2012, 09:27 AM

Tags for this Thread

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