SUMPRODUCT returns #VALUE error

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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
 
Thanks Paul - done the trick.

Cheers

John

PCLIVE said:
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
Click to expand...
 
Back
Top