Sum cost column based on date column and vlookup cost

[Mary L]

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.

 

[Jase]

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.

 

[Don Guillett]

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

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.