damondickeys
New Member
- Joined
- Apr 21, 2017
- Messages
- 3
Store | Employee | Job Code | Pay Rate | Total Hours | Total Pay |
CO-00202020 | employee # 1 | CASHIER | $7.50 | 89.82 | $898.20 |
CO-00202020 | employee # 2 | CATERING JOB CODE | $7.50 | 2.62 | $28.82 |
CO-00202020 | employee # 3 | ******* | $7.50 | 126.82 | $1,268.20 |
CO-00202020 | employee # 4 | ******* | $7.50 | 238.30 | $2,859.60 |
CO-00202020 | employee # 5 | CASHIER | $7.50 | 57.16 | $628.76 |
CO-00202020 | employee # 6 | CASHIER | $7.50 | 198.75 | $2,086.86 |
CO-00202020 | employee # 7 | CASHIER | $7.50 | 260.47 | $3,386.10 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
The above is the "raw" data.
This is what I'm using to get the data I'm looking for, but need to return multiple results. This is currently matching the store number and the job code just fine, but i need to see all the matches for the variables.
this gets me the total pay, by job code - but i need to get all of them across multuple columns
=IFERROR(INDEX('Labor Hours - Pay by Day'!$A$1:$F$3110,MATCH(1,('Labor Hours - Pay by Day'!$A$1:$A$3110=Sheet4!C2)*('Labor Hours - Pay by Day'!$C$1:$C$3110=Sheet4!$F$1),0),6),"none")
I also have another "helper" cell to count how many of each type of job codes are assigned to each store
=COUNTIFS('Labor Hours - Pay by Day'!$A:$A,Sheet4!C2,'Labor Hours - Pay by Day'!$C:$C,Sheet4!$F$1)
My summary sheet looks like this
R | D | S | Total | GMs | General Manager | General Manager | General Manager | General Manager |
4 | 5 | CA-20202020 | $ 6,801.42 | 1 | $ - | |||
4 | 5 | CA- | $ - | 2 | $ - | |||
4 | 5 | CA-0568 | $ 191.45 | 1 | $ - | |||
4 | 5 | CA-0723 | $ 2,398.19 | 0 | none |
<colgroup><col span="2"><col><col><col><col span="4"></colgroup><tbody>
</tbody>
can you help?