Percent distribution of total while eliminating certain values

[temple1]

Greetings!

I have attached a dummy workbook for my question.
I have a spreadsheet with the following columns:

Job Class | No. of employees | Type | % of total

What I need is to spread out $30,000 between Type S employees ONLY based on the number of employees in the associated job class. There are Type S and Type P employees, but I only this calculation for Type S employees. It might sound harder than it really is reading this.

Thank you for your time.

[shg]

In D2 and copy down,

=IF(C2<>"S", "", $D$8 * B2/ SUMIF($C$2:$C$7, "S", $B$2:$B$7))

The denominator could be calculated in a separate cell instead of calculating it redundantly in each row.

[temple1]

Worked perfectly! Thank you very much for a quick reply, shg!