Hi - I have a column with the date field "11/10/03" format and another column of numbers The number column is based on VLOOKUP command and will show a blank field if there is no value. I want to sum the number column for those
entries in November, for example. When I try this command

for example, the dates in B1:B10 it will sum the cells in C
=SUMPRODUCT((MONTH(B1:B10)=11)*(C1:C10))

I'm getting a #VALUE! error but since C column is based on a VLOOKUP and some fields are blank. Thank you in advance for yourreply.