finding the weighted average for certain groups within a large data set

[stewie1234]

Hello all,

I need to find the weighted average for multiple items within groups within a large data set and dont know if this can be done automatically. I have groups, say multiple investors for one loan and 261 loans. I need to find out the weighted average for each loan and am currently going through them individually. Is there a better way to do this???? Please, any help would be GREATLY APPRECIATED!

 

[RickXL]

Hi,

It is a bit difficult to provide a detailed example without any details of the data.

Microsoft has published this: https://support.microsoft.com/en-gb/kb/214049
And that is probably the approach I would adopt for a Worksheet solution.

Basically, you need to have some cells containing the weightings then you can use SUMPRODUCT() to multiply by all the weightings. You can use SUM() to determine the divisor.

Regards,