Median with multiple conditions and date

[Goddess]

Hi,

I need to find the median based on 2 conditions, one of which is the year of the date. A1:C15 is the table and the result I need is in H1:J5. Would be great if there's a formula without entered as array, but if need to, appreciate the help too.

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	Date	Description	Amount					2007	Grape	24325
2	18/6/2015	Apple	0					2015	Apple	0
3	29/7/2015	Orange	0					2015	Orange	0
4	12/8/2015	Banana	0					2015	Berry	6863
5	22/1/2007	Grape	0					2015	Banana	1769.82
6	21/12/2015	Banana	250.2
7	1/12/2015	Berry	375.3
8	4/10/2007	Grape	486.5
9	12/8/2015	Banana	556
10	12/8/2015	Banana	792.3
11	1/12/2015	Berry	997.3
12	12/8/2015	Banana	2747.34
13	12/8/2015	Banana	3239.4
14	7/9/2015	Banana	3712
15	12/8/2015	Banana	6395
16
17
Sheet1

Thanks!

 

[Peter_SSs]

Is this what you want?

25 01 25.xlsm
	A	B	C	D				H	I	J
1	Date	Description	Amount					2007	Grape	243.25
2	18/06/2015	Apple	0					2015	Apple	0
3	29/07/2015	Orange	0					2015	Orange	0
4	12/08/2015	Banana	0					2015	Berry	686.3
5	22/01/2007	Grape	0					2015	Banana	1769.82
6	21/12/2015	Banana	250.2
7	1/12/2015	Berry	375.3
8	4/10/2007	Grape	486.5
9	12/08/2015	Banana	556
10	12/08/2015	Banana	792.3
11	1/12/2015	Berry	997.3
12	12/08/2015	Banana	2747.34
13	12/08/2015	Banana	3239.4
14	7/09/2015	Banana	3712
15	12/08/2015	Banana	6395
16
Median

Cell Formulas
Range	Formula
J1:J5	J1	=MEDIAN(FILTER(C$2:C$15,(YEAR(A$2:A$15)=H1)*(B$2:B$15=I1)))

 

[Goddess]

Thanks Peter! Always a gem!!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.