Darren Blake
New Member
- Joined
- Oct 14, 2015
- Messages
- 1
Ok here goes, I have a spreadsheet which calculates each day the amount of work a colleague manages to achieve, however on some days the individual may not appear and my aim is to look up each day and sum the weekly amount for that person (e.g. AC, SG). My data is taken from pivot tables I have created but not matter what I use I can't the formula to look at Monday find the person, take the qauntity against that person (SUM of Cases) then look at Tuesday, Wednesday etc add them all together and return the result. I have tried to use SUMPRODUCT, SUMIFS, without success
HELP PLEASE
<colgroup><col style="width: 49px"><col width="53"><col width="52"><col width="41"><col width="74"><col width="82"><col width="9"><col width="51"><col width="52"><col width="56"><col width="53"><col width="82"><col width="80"><col width="9"><col width="50"><col width="59"><col width="62"><col width="52"><col width="83"><col width="82"><col width="10"><col width="51"><col width="64"><col width="59"><col width="57"><col width="78"><col width="79"><col width="11"><col width="45"><col width="55"><col width="54"><col width="49"><col width="81"><col width="84"></colgroup><tbody>
</tbody>
HELP PLEASE
Monday | Tuesday | Wednesday | Thursday | Friday | |||||||||||||||||||||||||||||
SUM of Cases | SUM of | Case Pick | Actual Pick Rate PH | Percentage | SUM of Cases | SUM of | Case Pick | Actual Pick Rate PH | Percentage | SUM of Cases | SUM of | Case Pick | Actual Pick Rate PH | Percentage | SUM of Cases | SUM of | Case Pick | Actual Pick Rate PH | Percentage | SUM of Cases | SUM of | Case Pick | Actual Pick Rate PH | Percentage | |||||||||
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
AC | 20 | 6 | 100 | 200.0 | 200.00% | AC | 10 | 1 | 100 | 600.0 | 600.00% | AC | 10 | 1 | 100 | 600.0 | 600.00% | SG | 10 | 60 | 100 | 10.0 | 10.00% | 100 | 0.0 | 0.00% | |||||||
SG | 10 | 4 | 100 | 150.0 | 150.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | ||||||||||||||||
100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | |||||||||||||||||||
100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | |||||||||||||||||||
100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | |||||||||||||||||||
100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | |||||||||||||||||||
100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | |||||||||||||||||||
100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | |||||||||||||||||||
100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | |||||||||||||||||||
100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | |||||||||||||||||||
100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% | 100 | 0.0 | 0.00% |
<colgroup><col style="width: 49px"><col width="53"><col width="52"><col width="41"><col width="74"><col width="82"><col width="9"><col width="51"><col width="52"><col width="56"><col width="53"><col width="82"><col width="80"><col width="9"><col width="50"><col width="59"><col width="62"><col width="52"><col width="83"><col width="82"><col width="10"><col width="51"><col width="64"><col width="59"><col width="57"><col width="78"><col width="79"><col width="11"><col width="45"><col width="55"><col width="54"><col width="49"><col width="81"><col width="84"></colgroup><tbody>
</tbody>