| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT returns #VALUE error
Thanks Paul - done the trick.
Cheers John "PCLIVE" wrote: Just use the single column reference. =SUMPRODUCT(--('Forecast Data'!A6:A61=A6),--('Forecast Data'!N6:N61='Client Forecast'!B9),'Forecast Data'!Q6:Q61) HTH, Paul -- "John" wrote in message ... Similar to the recently posted item I have a problem with a SUMPRODUCT returning a #VALUE error The formula is =SUMPRODUCT(--('Forecast Data'!A6:C61=A6),--('Forecast Data'!N6:O61='Client Forecast'!B9),'Forecast Data'!Q6:Q61) I think the problem lies in the fact that 'Forecast Data'!A6:C61 - the colums have merge cells in them - so Forecast Data'!A6-B6-C6 have been merged into one. The value in that merged cell is what the formula is trying to compare with the single cell - A6 Hope this makes sense and someone can help. John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct returns value error when ref is formula | Excel Discussion (Misc queries) | |||
| SumProduct Returns Zero | Excel Worksheet Functions | |||
| sumproduct returns zero | Excel Worksheet Functions | |||
| pleas help: sumproduct function returns #value or #ref error | Excel Worksheet Functions | |||
| sumproduct function returns #value or #ref error | Excel Worksheet Functions | |||
Hybrid Mode
