index/match multiple criteria - cant figure out how to return multiple results

[damondickeys]

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?

 

[Aladin Akyurek]

Which cell do you enter that IFERROR formula? And in which sheet?

 

[damondickeys]

Hello Aladin - sorry for not replying earlier, took a couple of days off from work!

I wound up using a pivot table to organize the data. It worked for the most part.

Many thanks!