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