SUM IF AND subtotal & filter dates

[Legacy 450260]

Hello i have list of fruits salles

i want when i filter by date it show the total of each fruits salles

 

[Aryatect]

Hi Try this:

Book1
	D	E	F	G	H	I	J	K	L	M
1									Name	Sales
2									Name 1	843
3									Name 2	239
4
5
6
7
8	Date	Sales	Name
9	6/1/2019	140	Name 1
10	6/1/2019	135	Name 2
11	6/3/2019	188	Name 1
12	6/4/2019	138	Name 4
13	6/5/2019	120	Name 1
14	6/6/2019	150	Name 6
15	6/2/2019	104	Name 2
16	6/1/2019	109	Name 1
17	6/9/2019	134	Name 9
18	6/10/2019	132	Name 10
19	6/11/2019	146	Name 1
20	6/12/2019	120	Name 12
21	6/13/2019	132	Name 13
22	6/14/2019	140	Name 1
Sheet4

Cell Formulas
Range	Formula
M2	{=SUM(IF($F$9:$F$22=L2,SUBTOTAL(109,OFFSET($E$9,ROW($E$9:$E$22)-ROW($E$9),))))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Legacy 450260]

not working bro

 

[Aryatect]

is the formula in the formula bar showing within curly brackets ? If not enter the formula and press ctrl+shift+enter