I want data in dealer wise sale sheet. I want data by matcing order from Summary sheet and sum shipment quantity and put the value under date column in Dealer wise sale report.
Sheet is attached
I want data in dealer wise sale sheet. I want data by matcing order from Summary sheet and sum shipment quantity and put the value under date column in Dealer wise sale report.
Sheet is attached
in I2 put
=SUMIFS('Summary Sheet'!$P:$P,'Summary Sheet'!$N:$N,$D2,'Summary Sheet'!$G:$G,"="&I$1)
and copy down and across
That sums the QTY in summary sheet column PI want data by matcing order from Summary sheet and sum shipment quantity and put the value under date column in Dealer wise sale report.
Then matches the order number on Summary sheet column N with the Order number in D
and then matches the Summary column G - Date - with the dates in the heading row 1
Last edited by etaf; 02-25-2018 at 10:36 AM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks