Forum Discussion
Solved
Conditional Weighted Average
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$...
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.
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?