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