How to get sum and avagerage of certain text using subtotal function

Dear Team,
I hope all are well and good.
I upload a file, in which I need to get the sum and average of time duration last column of the uploaded file,
for example when I filter exchange Name column and the exchange "ABC" I want to get the sum and average of all the entries of this exchange in time duration
column, similarly the other exchange name, DEF,GHI and so on...
Thanks a lot in advance pl.

sum in L1

Please Login or Register  to view this content.

average in M1

Please Login or Register  to view this content.

Thanks a lot Dear Team,
Mr. Windknife solution is as I required, because when filter exchange ABC it gives me only ABC and similarly when filter other Exchange names it gives me
the break up i mean sum and average of this exchange only..

You are welcome.
-----------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.

Hello Mr. what is this?

Hello Team,
I have also a new query for this If I want to count the no. of problems of any exchange for example Exchange ABC then what would be the
formula,
I am apologies for not ask it in the beginning also..
Thanks a lot in advance pl.

Try this,

Please Login or Register  to view this content.

Originally Posted by windknife

Try this,

Please Login or Register  to view this content.

Thanks a lot,
The formulas is working very well,
My all problems now solved.
May God bless you..