Hello,
I have 2 tables
1 table = promo list
2nd table = sales orders
I need a formula to populate Table 1 with the sales based on Table 2 if they fall the the promo date range by item by customer.
I tried a few different vlookups and sumifs and using primary keys but no luck yet
Hopes this makes sense and thank you in advance
Last edited by Nowherefast74; 04-19-2021 at 02:49 PM. Reason: uploading attachment
Please read the yellow banner at the top of this page on how to attach a file.
Thank you John...I just edited my thread to include an attachment file.
Hello All,
We can close this out...I figured it out by using Sumifs
Here's my formula in case others need it while doing a search
SUMIFS($D$14:$D$18,$A$14:$A$18,A5,$C$14:$C$18,C5,$B$14:$B$18,">="&D5,$B$14:$B$18,"<="&E5)
Thank you.
Good for you!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks