lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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.
<colgroup><col span="5"><col></colgroup><tbody>
</tbody>
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>