SUMPRODUCT returns #VALUE error

[John]

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

 

[PCLIVE]

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]

Thanks Paul - done the trick.

Cheers

John

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