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.


[TABLE="width: 100"]
<tbody>[TR]
[TD]vendor[/TD]
[TD]amount[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]44[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.