Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a total cost chart where a component cost is a step cost | Charts and Charting in Excel | |||
Marginal Abatement Cost - Creating a column chart | Charts and Charting in Excel | |||
INCREASE COST COLUMN BY A PERCENTAGE | Excel Worksheet Functions | |||
Current Cost versus Original Cost | New Users to Excel | |||
Confusion on adding percentage of cost to that cost. | Excel Worksheet Functions |