Google Spreadsheet sum when filtering

Question

I have spreadsheet that looks like this:

Now when I filter on a company I want the total to display the sum of the whole of B column.

Since I am very new to spreadsheets I was hoping someone could help me on how I would do that?

Answer 1

Use SUBTOTAL

=SUBTOTAL(9, B2:B20)