Apply filter then subtotal

Hi there,

I have a spreadsheet where users will filter it using autofilter. I then have two cells where the val/volume of each account is totalled, this works fine. However I would also like to be able to say which is the most recurring product within the account and how many times it occurs.

I have attached my sheet below, I hope this helps. Eg, Account 1 worst product is..... with a volume of...

Is this possible?
Thanks