How would you calculate it on paper?

I guess headcount would be Volume/(Set Targets X Hours Worked)

Assuming you have Volume in cell B2, Set Targets in C2, Hours Worked in D2
and you need the headcount in E2 then enter this formula in E2
=B2/(C2 * D2)

You can copy the formula down Col E if you have data in many rows.

If your formula is different then you can combine B2, C2 and D2 with +, - ,
* (for multiplication) and / (for division) as per your need.
"Vicky" wrote:

I need a formula which calc the required Head count

Task Volume Set Targets Hours worked Head Count
ABC 196500 85 3500 ?????

Thanks in Advance!!!!!
Vicky