Filter tool removing/hiding cells outside the table

[lezawang]

Hi
I have a table like the one below. I want to calculate sub total, sub salary etc.
So I selected cells beside the table and wrote subtotal functions. But the problem
When I filter any column, I might lose these cells as well (total count, total salary, min, max, average). How can I avoid that. Thank you so much.

name	sex	dept	salary
mary1	f	it	75879
alex1	m	hr	44295		total count
david1	m	sales	66277		total salary
john1	m	marketing	83008		max
aandy1	m	admin	10243		min
liz1	f	sales	58488		average
sarah1	f	marketing	33784

<colgroup><col span="5"><col></colgroup><tbody>
</tbody>

 

[Fluff]

Put them either below or above the table