filter and sub total

[lezawang]

Hi I want to filter the table below and then find the subtotal for that vendor. For example I want to filter vendor A and find the subtotal then filter vendor B and find the subtotal. Can I do that? I tried subtotal but did not work?
I tried =sum(b1:b10) but that would give me the total but the subtotal. Any idea please? Thank you.

vendor	amount
a	100
b	200
a	100
b	33
c	44

<tbody>
</tbody>

 

[Fluff]

Try
=SUBTOTAL(9,B1:B10)

 

[MARK858]

I think it will be

=SUBTOTAL(109,B1:B10)

as I believe it is only a sum of the visible cells required. 9 sums both the visible and hidden cells.