Conditional Weighted Average

[csieg8]

Hello,

I have successfully used the conditional weighted average formula

+SUMPRODUCT(--('Sheet2'!$A$2:$A$90=A2),'Sheet2'!$D$2:$D$90,'Sheet2'!$C$2:$C$90)/SUMIF('Sheet2'!$A$2:$A$90,A2,'Sheet2'!$C$2:$C$90)

and apparently, there is a limit of 89 values. The lookup part of the formula, Sheet2 data, is 242 values which is not letting letting me change the "90" to anything larger without getting an "N/A" error. 

Am I able to remove this limit? or is there a work around?

[#2 · Accepted solution]

@csieg8 

The formula should work with a much larger number of rows.

Check very carefully whether one of the cells in row 91 contains #N/A.

[#3]

There is NOT a limit of 89 values. i suggest that there may be an issue with the data (e.g. something in row 91) or an error in the formula when you change it. can you attach the book or a link to it?

[#4]

Thank you all, there was an error in sheet two on row 91. It works