Sum cost column based on date column and vlookup cost
 

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.

Sum cost column based on date column and vlookup cost
 

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.
.

Sum cost column based on date column and vlookup cost
 

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.