Nested sumproduct and indirect returns #VALUE error

Hi,

 

I have this formula to pick up values based on a specific criteria 

=SUMPRODUCT(((INDIRECT($B21&”!$C$26:$AAA$26″))=$C$19)*(INDIRECT($B21&”!$C$57:$AAA$60″)))

+SUMPRODUCT(((INDIRECT($B21&”!$C$120:$AAA$120″))=$C$19)*(INDIRECT($B21&”!$C$150:$C$153″)))

 

The first part works perfectly but the second part returns a #VALUE error. Iam using the same formula for 2 worksheets. It worked on the 1st worksheet but not on the other. 

 

Please advise.

 

By: adrian

Leave a Reply

Your email address will not be published. Required fields are marked *