Results 1 to 5 of 5

PRODUCTSUM Multiple criteria / Support

Threaded View

  1. #1
    Registered User
    Join Date
    04-02-2022
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    2

    PRODUCTSUM Multiple criteria / Support

    Hi All

    I've tried to figure this one out, we have

    Users (User's Name) moving items (StockCode) from (From Bin) one location to another (To Bin)
    Users (Column B) moving items (Column F) from (Column C) one location to another (Column D)


    Users are moving items from location to location (in & out) I'm trying to calculate the difference of the in and out transactions for the user over the entire report, some cases items go in but no out. This indication is in column G (StockCode) where the stock code is duplicated showing in and out movements. I'm wondering if anyone has any ideas? I've tried a few PRODUCTSUMs but i'm having a difficult time because column F values are stacked.

    I'd appreciate your review and support, thanks in advance
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by 6StringJazzer; 04-02-2022 at 10:02 PM. Reason: Moved from Outlook Formatting & Functions

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel Ranking with multiple criteria support
    By Hyperion1571 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2022, 06:29 AM
  2. Need help with productsum() and NA()
    By asgersax in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-19-2012, 10:27 AM
  3. PRODUCTSUM for different quantities
    By T86157 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 06-27-2012, 04:06 PM
  4. runtime 430 error- Class does not support Automation or does not support...
    By kimcole5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2012, 01:27 PM
  5. PRODUCTSUM of Each Duration for Each Category
    By T86157 in forum Excel General
    Replies: 0
    Last Post: 05-31-2012, 12:57 PM
  6. [SOLVED] Productsum: Multiple criteria; List highest sum first; Unique Categories
    By T86157 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-21-2012, 12:11 PM
  7. ProductSum/IF statment combination
    By excelmaster5000 in forum Excel General
    Replies: 1
    Last Post: 11-25-2009, 03:07 AM

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