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 ...
- Good to hear. Kindly mark as the Best Response😀.
Thanks
You can use VLOOKUP function to achieve that goal.. If possible to upload a sample file, that will make it easier to understand
Abiola1 Thanks for your reply.
Yes I thought VLOOKUP would work too but I am struggling with the formula.
I have attached a file as an example.
- 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