Advance/Complex Table pivot or filtering need

*	*	M.bed	M.bed	M.bed	C.bed	C.bed	C.bed	G.bed	G.bed	G.bed	G.bed	*
Apt	Floor	commod	basin	Light	basin	commod	basin	commod	basin	light	Soap	Status
A	1	3	3	2	4	1	3	5	4	2	3	unsold
B	1	4	2	5	3	1	4	4	4	1	3	unsold
A	2	4	1	0	0	4	1	2	1	2	1	L/O
B	2	4	1	4	0	0	3	5	4	3	4	L/O
A	3	3	2	2	2	2	2	5	3	3	4	unsold
B	3	1	1	4	2	1	1	4	1	4	4	sold
A	4	3	3	3	1	1	2	1	0	2	2	L/O
B	4	2	5	1	5	2	3	3	1	4	4	L/O
A	5	4	1	3	1	1	0	3	5	5	2	L/O
B	5	4	5	1	2	1	1	3	3	3	1	unsold

This is my table. Now I want belo report
1. Total commode
2. Total Basin
3. Total Light
4. Total Basin in Apt-B
5. Total Basin for L/O status
6. Total Basin for M.Bed
7. Total Commod for Apt-B of M.Bed
8. Total Basin for Apt-b of Sold status
9. Total Basin for Apt-A of C.Bed of L/O status
10. Total Basin for Floor 4
11. Total Basin for Apt-A of L/O

is it possible in excel ?