This should be easy but i keep getting #value! error, please help!

Row are date
Column are items
Data filled with numbers

I want to find sum within specific date range for the item.

=SUMPRODUCT(A:1:A8=A10,1:1>=B9,1:1<=B10,B2:Z10)

Item 1-Jan 2-Jan 3-Jan 4-Jan 5-Jan 6-Jan 7-Jan 8-Jan 9-Jan 10-Jan 11-Jan 12-Jan 13-Jan 14-Jan 15-Jan 16-Jan 17-Jan
Apple 1 2 3 4 5 6 7 8 9 10 11 12 13





1-Jan 8-Jan 15-Jan 22-Jan
7-Jan 14-Jan 21-Jan 28-Jan
Apple #VALUE!