Have you tried clicking in the formula cell, holding down
Shift and Ctrl then presing enter. This puts squiggly
brackets around the whole thing. And sometimes it fixes
these kind of problems
-----Original 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.
.