Weighted Average

[Brandy]

Hello,

I have attached a file I am working on to figure out the weighted average of two arrays: Target Incentive Opportunity and Year-end Performance Factor.

I would like to figure out the weighted average of both columns according to the job grade.

Is there a formula that would allow me to figure this out for the whole sheet or do I have to work through it by each job grade?

Thank you.

Brandy

[JBeaucaire]

Password protected attachment. Don't post the password, repost the file.

[Brandy]

Thanks for that...here is the file without the password.

As previously posted:

I have attached a file I am working on to figure out the weighted average of two arrays: Target Incentive Opportunity and Year-end Performance Factor.

I would like to figure out the weighted average of both columns according to the job grade.

Is there a formula that would allow me to figure this out for the whole sheet or do I have to work through it by each job grade?

Thank you.

Brandy