try adding isnumber to you formula
=SUMPRODUCT((MONTH(I5:I7)=11)*ISNUMBER(J5:J7))
--
Don Guillett
SalesAid Software

"Mary L" wrote in message
...
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.