weighted average

[Anonymous]

Hello guys, 

My question is preety straight forward, but I can't get this done. 

I want to calculate an weighted average on a table with number of days as below:

Country	HC	Working Days
Brazil	139	22,0
USA	12	19,0
Total	151	21,76

So basically I would need to average the number of days worked in a month for USA and Brazil having the Headcount as a paramenter, the results should be as the one in the table. 

Thanks!

[Anonymous]

Can someone please help me?

[jthomson · Accepted solution]

More or less the first google result, but anyway...

[Anonymous]

Thanks anyway!

[Anonymous]

To make it easier to understand, the mathematical formula would be ((Working days Brazil * HC Brazil)+(Working days USA * HC USA)) / (HC Brazil + HC USA)