Forum Discussion
Solved
Excel formula based on Date Range
Hello
I am trying to insert a total based on two assumptions.
I have two worksheets. One which shows a unique list of part numbers and the second worksheet that shows a list of all the part numbers history.
The part number is shown in the second worksheet and has several rows with the same name but different dates of when it was purchased.
I want to insert a total alongside the part shown on my first worksheet based on the qty bought within a date range ie for the year by looking up this information from my second worksheet.
Is this possible?
- Good to hear. Kindly mark as the Best Response😀.
Thanks
5 Replies
- You can use VLOOKUP function to achieve that goal.. If possible to upload a sample file, that will make it easier to understand
- Hello,
Kindly find the attached solution. Based on the structure of the data, the following are what I did on the data:
1. In the Ledger Entries, I created additional column where the extracted Year is located.
2. Convert the Ledger Entries into Table and named Data
3. Applied Named Range to Ledger Entries Columns
4. In the Solution sheet, I applied SUMIFS to sum up the Qualities based on the Item Number and the Year (2017, 2018, 2019).
5. Finally, I drag the formula across and down.
Looking forward to hear from you
