Sum cost column based on date column and vlookup cost

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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"
Click to expand...
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
Click to expand...
on a VLOOKUP and some fields are blank. Thank you in
advance for yourreply.
 
try adding isnumber to you formula
=SUMPRODUCT((MONTH(I5:I7)=11)*ISNUMBER(J5:J7))
--
Don Guillett
SalesAid Software
(e-mail address removed)
Mary L said:
Hi - I have a column with the date field "11/10/03" format and another
Click to expand...
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
Click to expand...
some fields are blank. Thank you in advance for yourreply.
 
Back
Top