[HELP] AverageIfs() with multiple criteria in both rows and columns

[Godofthunder12]

Can someone please help me with creating a formula which can take the average from a table, based on multiple criteria in both the rows and columns?

My first table is rather large but this is the basic layout :

	Time period :	1	1	1	2	2	2	3	3	3
	Week number :	10	11	12	13	14	15	16	17	18
Step	Test
A	TºC	32	33	31	35	29	36	33	32	31
A	pH	6.8	6.9	6.5	6.7	6.8	6.5	6.4	6.9	6.3
A	Salt	1.5	1.3	1.4	1.5	1.6	1.2	1.1	1.7	1.8
A	Fat	14	15	13	14	17	12	11	14	15
B	TºC	29	28	27	29	26	25	27	28	26
B	pH	6.5	6.4	6.7	6.3	6.2	6.1	6.5	6.4	6.3
B	Salt	1.4	1.5	1.6	1.1	1.2	1.7	1.2	1.3	1.4
B	Fat	23	24	27	23	26	24	27	28	24
C	TºC	17	16	18	15	17	15	16	19	14
C	pH	5.0	5.1	5.3	5.2	5.1	5.3	5.2	5.0	5.1
C	Salt	1.5	1.6	1.7	1.2	1.4	1.7	1.4	1.1	1.4
C	Fat	32	33	35	31	29	28	32	33	34

<tbody>
</tbody>

I have a second table in which I have columns for Step and Test and want to have the average by time period.

Any help would be greatly appreciated. Thanks!

 

[AstToTheRegionalMgr]

What are the criteria

 

[Godofthunder12]

I would like to have the average for each Step and Test by time periods (1,2,3). My second table is like this :

Step	Test	1	2	3
A	TºC
A	pH
A	Salt
A	Fat
B	TºC
B	pH
B	Salt
B	Fat
C	TºC
C	pH
C	Salt
C	Fat

<tbody>
</tbody>