Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula problem
Hi All,
Here's another I hope you can help with. Here's my formula that works fine: {=SUMPRODUCT(--($B$6:$B$417<DATE(2009,10,1)),--($Q$6:$Q$417=B463),$D $6:$D$417)} Now I want to change the end to ,$D$6:$O$417)}, but changing the D to an O gives the old #VALUE!. I don't suspect the cells in the formula because I'm using them with other similar formulas. Any help would be appreciated. Thanks, Michele |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem | Excel Worksheet Functions | |||
Problem with this formula | Excel Worksheet Functions | |||
Formula problem | Excel Worksheet Functions | |||
Formula problem | Excel Worksheet Functions | |||
Formula problem | Excel Worksheet Functions |