Average index match?

[joshbrfc]

Hi,

First post - sorry if this question has been asked before.

I want to calculate the following:

In the cell highlighted i want the average OEE calculation from the following tab:

I'm sure it will be easy for one of you!

 

[joshbrfc]

EDIT:

I want the average to match just for the week above it.

 

[joshbrfc]

Hello - any help on the above?

 

[AhoyNC]

Maybe something like this using AVERAGEIFS function.
Change ranges to match your data.

Book1
	A	B	C	D	E	F	G
1	Product					Week	Week
2						1	2
3	lsaderm					10714.5	12483.5
4	Cardisure					12566	11546.5
5
6
7		Output	Week
8	lsaderm	10760	1
9	Cardisure	12005	2
10	lsaderm	10669	1
11	lsaderm	12300	2
12	lsaderm	10550	3
13	Cardisure	11899	4
14	Cardisure	12566	1
15	Cardisure	11088	2
16	lsaderm	12667	2
Sheet1

Cell Formulas
Range	Formula
F3:G4	F3	=AVERAGEIFS($B$8:$B$16,$A$8:$A$16,$A3,$C$8:$C$16,F$2)