Sum function in filtered row

[Melika_Sn]

Hey guys,
I have an Excel file that I want to apply the sum-formula to the filtered rows as well. At present, the total value does not change when I filter the rows.

AM8=SUMIF(INDIRECT("Ordersheet!$AL$" & $AO$5 & ":$AL$" & $AO$8);INDIRECT("Ordersheet!$AK$" & $AO$5 & ":$AK$" & $AO$8);"<>NO";INDIRECT("Ordersheet!$AI$" & $AO$5 & ":$AI$" & $AO$8);"<>STORNO")
AO8 = =If (SUMPRODUCT(MAX(($A:$A<>"")*ROW($A:$A)))=7;8;SUMPRODUCT(MAX(($A:$A<>"")*ROW($A:$A))))
AO5=10

 

[JamesCanale]

The aggregate function should make quick work of it.

MrExcelPlayground8-1.xlsx
	A	B	C	D
1	Title		44	55
2	1
3	2
4	3
6	5
7	6
9	8
10	9
11	10
Sheet21

Cell Formulas
Range	Formula
C1	C1	=AGGREGATE(9,5,A2:A11)
D1	D1	=AGGREGATE(9,4,A2:A11)

 

[Melika_Sn]

The aggregate function should make quick work of it.

MrExcelPlayground8-1.xlsx
	A	B	C	D
1	Title		44	55
2	1
3	2
4	3
6	5
7	6
9	8
10	9
11	10
Sheet21

Cell Formulas
Range	Formula
C1	C1	=AGGREGATE(9,5,A2:A11)
D1	D1	=AGGREGATE(9,4,A2:A11)

Can you Please tell me how to add it to my formula? I get error