Sum filtered raw only

[Jagat Pavasia]

dear sir,
I have amount in C5:C28 and D5:D28.
I want total of C5:C28 in C2 and D5:D28 in D2.

but when filtered in other RAW then total only which shows.

For example :

If I filtered then :

So , which I formula or VBA code should apply ? please suggest me

 

[Jagat Pavasia]

Why can't you use the AGGREGATE function with option 4 (ignore nothing):

(my numbers are made up, i didn't want to recreate your scenario exactly).

Mr Excel Questions 71.xlsm
	A	B	C	D	E
1
2
3			179	159
Jagat Pavasia

Cell Formulas
Range	Formula
C3:D3	C3	=AGGREGATE(9,4,C5:C28)

Thanks a lots of......

I found formula in google is also helpful for me,
Like = Subtotal(109,C5:C28).


NOw i use this formula