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.
[TABLE="width: 395"]
<colgroup><col span="5"><col></colgroup><tbody>[TR]
[TD]name[/TD]
[TD]sex[/TD]
[TD]dept[/TD]
[TD]salary[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]mary1[/TD]
[TD]f[/TD]
[TD]it[/TD]
[TD]75879[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]alex1[/TD]
[TD]m[/TD]
[TD]hr[/TD]
[TD]44295[/TD]
[TD][/TD]
[TD]total count[/TD]
[/TR]
[TR]
[TD]david1[/TD]
[TD]m[/TD]
[TD]sales[/TD]
[TD]66277[/TD]
[TD][/TD]
[TD]total salary[/TD]
[/TR]
[TR]
[TD]john1[/TD]
[TD]m[/TD]
[TD]marketing[/TD]
[TD]83008[/TD]
[TD][/TD]
[TD]max[/TD]
[/TR]
[TR]
[TD]aandy1[/TD]
[TD]m[/TD]
[TD]admin[/TD]
[TD]10243[/TD]
[TD][/TD]
[TD]min[/TD]
[/TR]
[TR]
[TD]liz1[/TD]
[TD]f[/TD]
[TD]sales[/TD]
[TD]58488[/TD]
[TD][/TD]
[TD]average[/TD]
[/TR]
[TR]
[TD]sarah1[/TD]
[TD]f[/TD]
[TD]marketing[/TD]
[TD]33784[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Put them either below or above the table