Add total row for the report

[jimmy1986]

I have table like this

TEST.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1						TEST
2
3	DRIVER	NUMBER	NUMBER 2	DATE	NUMBER3	CUS	NUMBER 4	KG	MONEY	NUMBER5	NUBER6	NUMBER7
4	DRIVER1	31517	MERGE1	44805	281	A	2T2	2165.8	1	50000	500000	550000
5	DRIVER1	31517	MERGE1	44805	282	A	2T2	481.1	1	50000	500000	550000
6	DRIVER1	31517		44820	127	A	2T1	1980	1	0	1200000	1200000
7	DRIVER4	86523	MERGE2	44805	283	A	2T2	1511.7	1	50000	500000	550000
8	DRIVER4	86523	MERGE2	44805	284	A	2T2	537.8	1	50000	500000	550000
9	DRIVER2	17050		44805	285	A	2T1	3763	1	0	1000000	1000000
10	DRIVER3	13668		44805	286	A	5T1	5477.5	1	0	1600000	1600000
11	DRIVER6	1918		44805	287	A	5T1	4799.7	1	0	1600000	1600000
12	DRIVER2	17050		44805	288	A	2T1	3834.8	1	0	1000000	1000000
13	DRIVER4	86523		44805	289	A	2T1	2192.9	1	0	1200000	1200000
14	DRIVER7	9976		44805	290	A	5T1	5943.2	1	0	1600000	1600000
15	DRIVER1	31517		44809	1	A	2T1	2039.5	1	0	1000000	1000000
16	DRIVER4	86523		44809	2	A	2T1	2116.2	1	0	1000000	1000000
17	DRIVER7	9976		44809	3	A	5T1	5397.6	1	0	1600000	1600000
18	DRIVER3	13668		44809	4	A	5T1	6195.9	1	0	3400000	3400000
19	DRIVER4	86523		44816	77	A	2T1	1867.8	1	0	1400000	1400000
20	DRIVER1	31517		44809	5	A	2T1	2196.2	1	0	1000000	1000000
21	DRIVER2	17050		44809	6	A	2T2	1196.6	1	50000	500000	550000
22	DRIVER2	17050		44809	7	A	2T2	1407.6	1	50000	500000	550000
23	DRIVER7	6509		44809	8	A	5T2	3146.6	1	50000	800000	850000
24	DRIVER7	6509		44809	9	A	5T2	602.7	1	50000	800000	850000
25	DRIVER5	34967		44821	132	A	2T2	1012	1	50000	700000	750000
26	DRIVER4	86523		44809	10	A	2T1	3675.1	1	0	500000	500000
27	DRIVER7	9976		44809	11	A	2T1	5580.2	1	0	0	0
28	DRIVER2	17050		44820	118	A	2T2	455.9	1	50000	500000	550000
29
Sheet1

I NEED TO TURN TO THIS REPORT

TEST.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1
2
3	DRIVER	NUMBER	NUMBER 2	DATE	NUMBER3	CUS	NUMBER 4	KG	MONEY	NUMBER5	NUBER6	NUMBER7
4	DRIVER1	31517	MERGE1	44805	281	A	2T2	2165.8	1	50000	500000	1100000
5	DRIVER1	31517	MERGE1	44805	282	A	2T2	481.1	1	50000	500000
6	DRIVER1	31517		44820	127	A	2T1	1980	1	0	1200000	1200000
7	DRIVER1	31517		44809	1	A	2T1	2039.5	1	0	1000000	1000000
8	DRIVER1	31517		44809	5	A	2T1	2196.2	1	0	1000000	1000000
9										TOTAL DRIVER 1		43000000
10	DRIVER2	17050		44805	285	A	2T1	3763	1	0	1000000	1000000
11	DRIVER2	17050		44805	288	A	2T1	3834.8	1	0	1000000	1000000
12	DRIVER2	17050		44809	6	A	2T2	1196.6	1	50000	500000	550000
13	DRIVER2	17050		44809	7	A	2T2	1407.6	1	50000	500000	550000
14	DRIVER2	17050		44820	118	A	2T2	455.9	1	50000	500000	550000
15										TOTAL DRIVER 2		3650000
16	DRIVER3	13668		44805	286	A	5T1	5477.5	1	0	1600000	1600000
17	DRIVER3	13668		44809	4	A	5T1	6195.9	1	0	3400000	3400000
18										TOTAL DRIVER 3		5000000
19	DRIVER4	86523	MERGE2	44805	283	A	2T2	1511.7	1	50000	500000	110000
20	DRIVER4	86523	MERGE2	44805	284	A	2T2	537.8	1	50000	500000
21	DRIVER4	86523		44805	289	A	2T1	2192.9	1	0	1200000	1200000
22	DRIVER4	86523		44809	2	A	2T1	2116.2	1	0	1000000	1000000
23	DRIVER4	86523		44816	77	A	2T1	1867.8	1	0	1400000	1400000
24	DRIVER4	86523		44809	10	A	2T1	3675.1	1	0	500000	500000
25										TOTAL DRIVER 4		52000000
26	DRIVER5	34967		44821	132	A	2T2	1012	1	50000	700000	52000000
27										TOTAL DRIVER 5		43000000
28	DRIVER6	1918		44805	287	A	5T1	4799.7	1	0	1600000	43000000
29										TOTAL DRIVER 6		43000000
30	DRIVER7	9976		44805	290	A	5T1	5943.2	1	0	1600000	1600000
31	DRIVER7	9976		44809	3	A	5T1	5397.6	1	0	1600000	1600000
32	DRIVER7	6509		44809	8	A	5T2	3146.6	1	50000	800000	850000
33	DRIVER7	6509		44809	9	A	5T2	602.7	1	50000	800000	850000
34	DRIVER7	9976		44809	11	A	2T1	5580.2	1	0	0	0
35										TOTAL DRIVER 7		49000000
36
Sheet2

MAIN TASK:
1. FILTER COLUMN DRIVER ( COLUMN A) FROM A TO Z)
2. INSERT 1 TOTAL ROW FOR EACH DRIVER. COUNT THE TOTAL FOR THAT DRIVER IN COLUMN L (NUMBER7)


ADĐITIONAL TASK

3.FIND IN COLUMN C IF SAME WORD , MERGE AND SUM AND CENTER IN COLUM L

I AM APPRICIATE FOR THE HELP. THANK YOU

 

[Fluff]

Duplicate to: How to sum 2 merge cells.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.