+ Reply to Thread
Results 1 to 3 of 3

Inventory Tracking - Formula to find beginning inventory and ending inventory based

  1. #1
    Forum Contributor
    Join Date
    12-20-2017
    Location
    California
    MS-Off Ver
    Office 365
    Posts
    104

    Inventory Tracking - Formula to find beginning inventory and ending inventory based

    Hello,

    I've attached a worksheet that I could use some help on. I need to find beginning inventory based on date in cell J3 as it relates to each commodity shown in I10, down. Also need to find ending inventory as of date shown in J4.

    Thanks in advance for the help.

    -Manny
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,178

    Re: Inventory Tracking - Formula to find beginning inventory and ending inventory based

    In J10

    =SUMIFS(TblDelv[Tons],TblDelv[Commodity],I10,TblDelv[Date],"<=" &$J$3)

    in K10

    =SUMIFS(TblDelv[Tons],TblDelv[Commodity],I10,TblDelv[Date],"<=" &$J$4)

    copy both down

  3. #3
    Forum Contributor
    Join Date
    12-20-2017
    Location
    California
    MS-Off Ver
    Office 365
    Posts
    104

    Re: Inventory Tracking - Formula to find beginning inventory and ending inventory based

    Worked perfectly. Very appreciated.

    -Manny

+ 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: 3
    Last Post: 11-05-2020, 12:08 PM
  2. Replies: 5
    Last Post: 10-18-2020, 03:56 AM
  3. [SOLVED] Formula for Inventory Summary based on Inventory List
    By EWolfe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-19-2018, 10:35 AM
  4. Replies: 0
    Last Post: 09-04-2018, 02:52 AM
  5. Replies: 5
    Last Post: 04-30-2014, 05:46 PM
  6. Replies: 0
    Last Post: 04-29-2014, 01:01 PM
  7. Inventory Age Formula Needed for FIFO Inventory
    By SWeisser in forum Excel General
    Replies: 0
    Last Post: 07-20-2012, 02:44 PM

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