Suppose you have your data in this format with headers in row 1

A2:A71 --Employee Names
B2:B71 --Current Salary
Try this formula in C2 and copy that down upto c71

= B2/SUM($B$2:$B$71)*1400000

If this post helps click Yes
---------------
Jacob Skaria


"Denise" wrote:

I need to distribute benefits costs across a group of employees based on
salary. The higher the salary the higher the portion of benefits cost. I have
a group of 70 employees, total benefit costs of 1.4m.
Thanks for your help!