Hello Friends

I've got the dates of the year (mm/dd/yyyy) in col A from row 87 to 452.
I've got the number of employes I used on that date next to the date in col
B. What I want is to have 1-52 in Col A at the top of the sheet and the
number of employees I used in that week of the year across from the
corresponding number in Col B. I've tried
=SUMPRODUCT((WEEKNUM($A$87:$A$452)=A1)*(B$87:B$452 )) but keep getting a
#VALUE! error.

Thanks for any and all help. I appreciate your being there!

Sam