Nested sumproduct and indirect returns #VALUE error



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




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 *