Help with a formula

[Ali3ta1r]

Hi all,

I am trying to devise a formula where I can filter my Excel sheet by Letter (Column F) so that the Average (Cell L12) will update to only account for the filtered results (the Average is taken from the Diff numbers in Column L).

Does that make sense?

Dec - March.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	Date	Time	Course	Name	Bet	Letter	R-odds	Pos	BSP	Lo Fig		Diff
2	01/12/2020	15.15	Limerick	Ballyshannon Rose	Win	A	5.50	1st	5.40	1.01		4.39
3	01/12/2020	15.15	Limerick	Solar Heat	Each Way	B	26.00		70.00	12.50		57.50
4	01/12/2020	12.20	Lingfield	Brave Bairn	Each Way	A	13.00		10.00	6.00		4.00
5	01/12/2020	12.50	Lingfield	Anythingforlove	Win	C	2.00	1st	1.50	1.01		0.49
6	01/12/2020	13.20	Lingfield	Gallic Geordie	Win	A	19.00	1st	42.71	1.01		41.70
7	01/12/2020	13.20	Lingfield	Tis Fantastic	Win	G	4.00		3.94	3.70		0.24
8	01/12/2020	14.23	Lingfield	Darlyn	Win	H	6.50		6.00	5.90		0.10
9	01/12/2020	14.23	Lingfield	Fricka	Win	B	11.00		7.20	6.80		0.40
10	01/12/2020	14.53	Lingfield	Finnegans Garden	Win	C	4.00		6.85	2.10		4.75
11	01/12/2020	15.23	Lingfield	Little Rory Mac	Win	C	2.75		2.42	1.57		0.85
12											AVERAGE	11.44
Sheet1

Cell Formulas
Range	Formula
L2:L11	L2	=I2-J2
L12	L12	=AVERAGE(L2:L11)

 

[Tom Urtis]

Try
=AGGREGATE(1,5,L2:L11)

 

[Fluff]

Another option

=SUBTOTAL(101,L2:L11)