jackdiamond
Board Regular
- Joined
- Oct 10, 2007
- Messages
- 220
Hi,
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
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