Count annual issued items

Hi all,

Marry Christmas And Happy New Year

I have list with 20000 rows, I need to count total annual issued qty. please find attached sample for more details. I have solved. I used pivot table.
Just want to see if there any easy way?

Thank you for your time

Here's a solution which uses formulae to acheive the same outcome. It relies upon you knowing what the unique list of item #'s is at the outset.

Please see the attachment.

Sorry - my mistake.

Please have a look at the new attachment.