Forum Discussion
Solved
Summing the number of instances of an item in each year
Hi all, first time asking a question here so please bear with me. I have a large table of ID Nos. that are listed by the multiple dates they mentioned in our system. As well as sorting the li...
There are several ways to do that
I would recommend you using Tables and Pivot Table.
First converting your range into an Excel Table.
Them applying a pivot table.
Another solution is using formulas with your range as Table.
=SUMPRODUCT((YEAR(MyData[Date])=H5)*(MyData[ID'#]=G5))Find attached an example.
Boss was extremely happy with the result! Thank you again!!
Kind regards
JD
Kind regards
JD
Anytime my friend.