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

Sale Point	Trans	Qty	% age
	AM Total	180.00	4.4%
	AN Total	60.00	1.5%
	FM Total	65.00	1.6%
	IC Total	60.00	1.5%
	MB Total	590.00	14.5%
	ME Total	130.00	3.2%
	MG Total	610.00	15.0%
	PC Total	430.00	10.6%
	RE Total	365.00	9.0%
	SB Total	170.00	4.2%
	SG Total	520.00	12.8%
	SHI Total	250.00	6.1%
	TA Total	195.00	4.8%
	WB Total	350.00	8.6%
	WWC Total	100.00	2.5%
GAGOO MANDI Total		4075.00
	AN Total	70.00	10.0%
	GE Total	70.00	10.0%
	ME Total	140.00	20.0%
	RE Total	140.00	20.0%
	SG Total	70.00	10.0%
	TA Total	70.00	10.0%
	WWC Total	140.00	20.0%
BUREWALA Total		700.00
	AM Total	120.00	5.4%
	AN Total	100.00	4.5%
	FM Total	240.00	10.9%
	IC Total	50.00	2.3%
	ME Total	190.00	8.6%
	MG Total	320.00	14.5%
	PC Total	60.00	2.7%
	RE Total	170.00	7.7%
	SB Total	5.00	0.2%
	SG Total	235.00	10.7%
	SHI Total	135.00	6.1%
	TA Total	210.00	9.5%
	WB Total	230.00	10.4%
	WWC Total	140.00	6.3%
KHANEWAL Total		2205.00

<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>

Table 2

Trans Qty %age AM Total AN Total FM Total IC Total ME Total MG Total PC Total RE Total SB Total SG Total SHI Total TA Total WB Total WWC Total <colgroup><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[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.