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.
Thank you all, there was an error in sheet two on row 91. It works