#### jackdiamond

##### Board Regular

- Joined
- Oct 10, 2007

- Messages
- 220

I currently use this formula which tells me a % of how much work someone does to the rest of his shift.

=SUMPRODUCT(($P$6:$P$24)*($B$6:$B$24="KEVIN MENHAM"))/SUMPRODUCT(($P$6:$P$24)*($A$6:$A$24="A"))*100

If I had hours worked in column "W", Does anyone know how I could work this into the formula so it would give the correct % for hours worked?

For background info

Column P is entry total

Column B is the names of workers

Column a is which shift they work on

i hope this is not to vague

Thanks

Stu