+ Reply to Thread
Results 1 to 2 of 2

Formula for Inventory Summary based on Inventory List

  1. #1
    Registered User
    Join Date
    05-09-2017
    Location
    Edmonton, Alberta
    MS-Off Ver
    2016
    Posts
    61

    Formula for Inventory Summary based on Inventory List

    I am trying to come up with a formula on the 'Summary' tab (of the attached excel) based on the data existing in the 'Inventory' tab
    On the Inventory tab I have some inventory items, they are separated by Item Type, Item, Long/Short Sleeve, Size, who they are Assigned To and Qty.
    On the Summary tab I would like the B3 & B4 to analyze the data in the Inventory tab and count based on that criteria.

    For example:
    I would like cell B3 to look in the Inventory tab for: Shirt in Column B, and for Dress Shirt in Column C, and for Long Sleeve in Column D, and for M, in Column E.
    When it finds a combination of all of those then I would like it to count how many instances that occurs.
    In the example, it should find 2.

    Thank you for your help.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Formula for Inventory Summary based on Inventory List

    Have a look here (a very similar problem): https://www.excelforum.com/excel-for...-criteria.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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: 0
    Last Post: 09-04-2018, 02:52 AM
  2. [SOLVED] index match inventory list generated from another inventory list
    By dmike23 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-01-2017, 11:08 AM
  3. Replies: 5
    Last Post: 04-30-2014, 05:46 PM
  4. Replies: 0
    Last Post: 04-29-2014, 01:01 PM
  5. List Index based Inventory Application Help
    By Kurokojin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-11-2014, 11:27 PM
  6. Inventory Age Formula Needed for FIFO Inventory
    By SWeisser in forum Excel General
    Replies: 0
    Last Post: 07-20-2012, 02:44 PM
  7. Replies: 0
    Last Post: 10-04-2005, 08:05 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