Forum Discussion
Excel Formula
Jeng Chi Order Guide 2024.xlsm
Please again I need your help!!, I need to track the order by date, but show me the same number even it is different item , thank you
You can make this task much easier by doing a few things:
1. Name the table on the Order Log sheet
2. Define the dates as a named item in the Order Tracker sheet
3. Spill the the product and vendors
Then you can use a single input to obtain all the totals in the grid:
=SUMIFS(OrderLogTbl[Order], OrderLogTbl[Date], dates, OrderLogTbl[Vendor], B6#, OrderLogTbl[Product Name], A6#)
You can make this task much easier by doing a few things:
1. Name the table on the Order Log sheet
2. Define the dates as a named item in the Order Tracker sheet
3. Spill the the product and vendors
Then you can use a single input to obtain all the totals in the grid:
=SUMIFS(OrderLogTbl[Order], OrderLogTbl[Date], dates, OrderLogTbl[Vendor], B6#, OrderLogTbl[Product Name], A6#)- thank you so much for your help!!
- You're welcome!
