I am using SUMPRODUCT/SUM for mutiple sets of data to get the combined weighted average.
I have done this by adding (SUMPRODUCT/SUM)+(SUMPRODUCT/SUM) mutiple times. It doesn't work unfortunately. How can this be done please? I need some help.
I have done this by adding (SUMPRODUCT/SUM)+(SUMPRODUCT/SUM) mutiple times. It doesn't work unfortunately. How can this be done please? I need some help.