NEED A Code for my Excel sheet to calculate year total for each items in the list.

[Samexcel]

hi everyone,

i need a VBA code for my sheet. and in that sheet i need the sum of each items year qty, i have attached a example sheet to this request. in this sheet i have three items in the first columns and there value are given in date wise columns. i need a code to add the values of each item for each year. please have a look and suggest me a code.

[nevadaDave]

It sounds pretty basic. However, I can't open your file because I'm stuck at office 2003.
If you could repost with a .xls file, I could help.

[Samexcel]

Hi Dave,

i am uploading the 2003 version of the file so that you can see.

[CheshireCat]

No need for VBA, a formula will do the job.

In cell B11 paste:

=SUMPRODUCT(--(YEAR($B$1:$H$1)=B$10),INDEX($B$2:$H$4,MATCH($A11,$A$2:$A$4,0),0))

Copy/autofill across & down.

[Samexcel]

Thanks a lot it is solving my problem.