finding and sum duplicate values

[azii]

I have the data and want to sum duplicate values in the cells . table data is given below as table 1.
(e.g. AN total is appearing more than one time so I want to sum of qty of "AN total" in table 2 in front of AN total.
Please help me resolve this issue.

table 1
[TABLE="width: 308"]
<colgroup><col><col span="2"><col></colgroup><tbody>[TR]
[TD]Sale Point[/TD]
[TD]Trans[/TD]
[TD] Qty[/TD]
[TD] % age[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]AM Total[/TD]
[TD="align: right"]180.00[/TD]
[TD="align: right"]4.4%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]AN Total[/TD]
[TD="align: right"]60.00[/TD]
[TD="align: right"]1.5%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]FM Total[/TD]
[TD="align: right"]65.00[/TD]
[TD="align: right"]1.6%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]IC Total[/TD]
[TD="align: right"]60.00[/TD]
[TD="align: right"]1.5%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MB Total[/TD]
[TD="align: right"]590.00[/TD]
[TD="align: right"]14.5%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ME Total[/TD]
[TD="align: right"]130.00[/TD]
[TD="align: right"]3.2%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MG Total[/TD]
[TD="align: right"]610.00[/TD]
[TD="align: right"]15.0%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]PC Total[/TD]
[TD="align: right"]430.00[/TD]
[TD="align: right"]10.6%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]RE Total[/TD]
[TD="align: right"]365.00[/TD]
[TD="align: right"]9.0%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SB Total[/TD]
[TD="align: right"]170.00[/TD]
[TD="align: right"]4.2%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SG Total[/TD]
[TD="align: right"]520.00[/TD]
[TD="align: right"]12.8%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SHI Total[/TD]
[TD="align: right"]250.00[/TD]
[TD="align: right"]6.1%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]TA Total[/TD]
[TD="align: right"]195.00[/TD]
[TD="align: right"]4.8%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]WB Total[/TD]
[TD="align: right"]350.00[/TD]
[TD="align: right"]8.6%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]WWC Total[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]2.5%[/TD]
[/TR]
[TR]
[TD]GAGOO MANDI Total[/TD]
[TD][/TD]
[TD="align: right"]4075.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]AN Total[/TD]
[TD="align: right"]70.00[/TD]
[TD="align: right"]10.0%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]GE Total[/TD]
[TD="align: right"]70.00[/TD]
[TD="align: right"]10.0%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ME Total[/TD]
[TD="align: right"]140.00[/TD]
[TD="align: right"]20.0%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]RE Total[/TD]
[TD="align: right"]140.00[/TD]
[TD="align: right"]20.0%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SG Total[/TD]
[TD="align: right"]70.00[/TD]
[TD="align: right"]10.0%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]TA Total[/TD]
[TD="align: right"]70.00[/TD]
[TD="align: right"]10.0%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]WWC Total[/TD]
[TD="align: right"]140.00[/TD]
[TD="align: right"]20.0%[/TD]
[/TR]
[TR]
[TD]BUREWALA Total[/TD]
[TD][/TD]
[TD="align: right"]700.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]AM Total[/TD]
[TD="align: right"]120.00[/TD]
[TD="align: right"]5.4%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]AN Total[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]4.5%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]FM Total[/TD]
[TD="align: right"]240.00[/TD]
[TD="align: right"]10.9%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]IC Total[/TD]
[TD="align: right"]50.00[/TD]
[TD="align: right"]2.3%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ME Total[/TD]
[TD="align: right"]190.00[/TD]
[TD="align: right"]8.6%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MG Total[/TD]
[TD="align: right"]320.00[/TD]
[TD="align: right"]14.5%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]PC Total[/TD]
[TD="align: right"]60.00[/TD]
[TD="align: right"]2.7%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]RE Total[/TD]
[TD="align: right"]170.00[/TD]
[TD="align: right"]7.7%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SB Total[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]0.2%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SG Total[/TD]
[TD="align: right"]235.00[/TD]
[TD="align: right"]10.7%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SHI Total[/TD]
[TD="align: right"]135.00[/TD]
[TD="align: right"]6.1%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]TA Total[/TD]
[TD="align: right"]210.00[/TD]
[TD="align: right"]9.5%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]WB Total[/TD]
[TD="align: right"]230.00[/TD]
[TD="align: right"]10.4%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]WWC Total[/TD]
[TD="align: right"]140.00[/TD]
[TD="align: right"]6.3%[/TD]
[/TR]
[TR]
[TD]KHANEWAL Total[/TD]
[TD][/TD]
[TD="align: right"]2205.00[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Table 2

[TABLE="width: 246"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 256"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Trans[/TD]
[TD]Qty[/TD]
[TD]%age[/TD]
[/TR]
[TR]
[TD]AM Total[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]AN Total[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]FM Total[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]IC Total[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ME Total[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]MG Total[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PC Total[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]RE Total[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SB Total[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SG Total[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SHI Total[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TA Total[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]WB Total[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]WWC Total[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[texasalynn]

is this what you need?

Excel 2010
	A	B	C	D
1	table 1
2	Sale Point	Trans	Qty	% age
3		AM Total	180	4.4%
4		AN Total	60	1.5%
5		FM Total	65	1.6%
6		IC Total	60	1.5%
7		MB Total	590	14.5%
8		ME Total	130	3.2%
9		MG Total	610	15.0%
10		PC Total	430	10.6%
11		RE Total	365	9.0%
12		SB Total	170	4.2%
13		SG Total	520	12.8%
14		SHI Total	250	6.1%
15		TA Total	195	4.8%
16		WB Total	350	8.6%
17		WWC Total	100	2.5%
18	GAGOO MANDI Total		4075
19		AN Total	70	10.0%
20		GE Total	70	10.0%
21		ME Total	140	20.0%
22		RE Total	140	20.0%
23		SG Total	70	10.0%
24		TA Total	70	10.0%
25		WWC Total	140	20.0%
26	BUREWALA Total		700
27		AM Total	120	5.4%
28		AN Total	100	4.5%
29		FM Total	240	10.9%
30		IC Total	50	2.3%
31		ME Total	190	8.6%
32		MG Total	320	14.5%
33		PC Total	60	2.7%
34		RE Total	170	7.7%
35		SB Total	5	0.2%
36		SG Total	235	10.7%
37		SHI Total	135	6.1%
38		TA Total	210	9.5%
39		WB Total	230	10.4%
40		WWC Total	140	6.3%
41	KHANEWAL Total		2205
Sheet2

Excel 2010
	G	H	I
1	Table 2
2
3	Trans	Qty	%age
4	AM Total	2	9.8%
5	AN Total	3	16.0%
6	FM Total	2	12.5%
7	IC Total	2	3.8%
8	ME Total	3	31.8%
9	MG Total	2	29.5%
10	PC Total	2	13.3%
11	RE Total	3	36.7%
12	SB Total	2	4.4%
13	SG Total	3	33.5%
14	SHI Total	2	12.2%
15	TA Total	3	24.3%
16	WB Total	2	19.0%
17	WWC Total	3	28.8%
Sheet2

Cell Formulas
Range	Formula
H4	=COUNTIF($B$3:$B$40,G4)
I4	=SUMIF($B$3:$B$40,G4,$D$3:$D$40)

 

[azii]

thanks texasalynn
I was a complete solution. great work.

Proud to have such an reply from you.

thanks again.