Averageif w/ multiple criteria - trying to grab the right row

[patrickjpatten]

I'm just having a real difficulty doing this and I can't figure it out. I'm sorry. I just don't know what formula to put in there to grab the right average. I have the months across the top i just don't know to create a dynamic averageif function inside the [average_range] criteria.... basically i know i can hard code inside those "?" but i'd like it to be more dynamic, like i can stick Pears, apples, or bananas in and it'd work
as

	1​	1​	1​	2​	2​	2​	3​	3​	3​
	1/1/2023​	1/2/2023​	1/3/2023​	2/1/2023​	2/2/2023​	2/3/2023​	3/1/2023​	3/2/2023​	3/3/2023​
Pears	1.25​	1.5​	1.35​	1.42​	1.68​	2.05​	2.25​	2.5​	2.35​
Apples	3.15​	3.14​	3.16​	3.08​	3.02​	3.7​	4.2​	4.25​	4.05​
Bananas	2.5​	2.45​	1.55​	2.65​	2.75​	2.68​	2.42​	2.31​	2.56​
	Month		Average
	1​	Pears	?
	1​	Apples	?
	​

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J
1		1	1	1	2	2	2	3	3	3
2		01/01/2023	02/01/2023	03/01/2023	01/02/2023	02/02/2023	03/02/2023	01/03/2023	02/03/2023	03/03/2023
3	Pears	1.25	1.5	1.35	1.42	1.68	2.05	2.25	2.5	2.35
4	Apples	3.15	3.14	3.16	3.08	3.02	3.7	4.2	4.25	4.05
5	Bananas	2.5	2.45	1.55	2.65	2.75	2.68	2.42	2.31	2.56
6
7		Month		Average
8		1	Pears	1.3666667
9		1	Apples	3.15
Main

Cell Formulas
Range	Formula
D8:D9	D8	=AVERAGE(FILTER(FILTER($B$3:$J$5,$A$3:$A$5=C8),$B$1:$J$1=B8))

 

[patrickjpatten]

Thank you so much! This is the best board!

 

[Fluff]

You're welcome & thanks for the feedback.