+ Reply to Thread
Results 1 to 2 of 2

Tracking inventory in and out from multiple sheets. Not sure how to write formula?

  1. #1
    Registered User
    Join Date
    02-02-2023
    Location
    Alberta
    MS-Off Ver
    MS 365
    Posts
    1

    Tracking inventory in and out from multiple sheets. Not sure how to write formula?

    I have created my inventory list.
    I would like to track current inventory.
    I have 4 different sheets that track the quantity of promo items going out. (Programs, Other Events, Donations, Sales)
    As well as an additional sheet for Inventory Received (INQTY).
    I have named all 5 Quantity columns by using the define name option. Names are: INQTY, OUTQTY1, OUTQTY2, OUTQTY3, OUTQTY4.
    I understand using this formula =SUMIF(INOUTCODE,C4,INQTY) will work with 1 colmn of data but HOW DO I write the formula to include all 5 columns of data (INQTY, OUTQTY1, OUTQTY2, OUTQTY3, OUTQTY4)?
    Any help would be greatly appreciated.
    Thank you!

  2. #2
    Registered User
    Join Date
    01-05-2022
    Location
    Indonesia
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    49

    Re: Tracking inventory in and out from multiple sheets. Not sure how to write formula?

    so you mean
    Sumif column 1 from cell C4, then sumif again column 2 from cell C4, then sumif again and so on until column 5 (OUTQTY4)

    Sorry but I find it a bit difficult to understand without the example file attached, please read the yellow box above
    I'm not an expert, but I'll try

+ 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. Inventory Tracking Formula
    By Piotrski in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-18-2023, 10:43 AM
  2. Help with multiple formulas for inventory tracking
    By OfficeKirby in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-20-2021, 09:44 PM
  3. [SOLVED] Inventory Tracking - Formula to find beginning inventory and ending inventory based
    By Prof Sick in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2021, 02:11 PM
  4. Inventory tracking formulas and formula for discounts or bulk buying
    By kareylee in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-10-2020, 01:56 AM
  5. [SOLVED] Trying to Write a formula to calculate available inventory
    By OilAndGasMan1984 in forum Excel General
    Replies: 11
    Last Post: 09-19-2019, 02:43 PM
  6. Formula Needed - Inventory Tracking
    By Rterp44 in forum Excel General
    Replies: 1
    Last Post: 03-19-2019, 04:02 AM
  7. [SOLVED] Formula for Inventory that calulates an item using different components and tracking of
    By mpost54 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-15-2018, 03:13 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