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.
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.
Thank you Juliano-Petrukio!! I really appreciate you spending your time to help me out on that.
I'll let you know how it goes.
Cheers
JD
I'll let you know how it goes.
Cheers
JD