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!
- Hey Patrick, I need your help!! Please access to my file, please check the formula because it doesn't show me the values!!! you can edit the file!!! Please and thank you, please accept my apologies.! thank you. I am learning!!!
