To add duplicate values in excel2007

[bhanugollapudi]

Hi,

I want to add the repeated entries values.can u help on this

Ex:

Element down time
CHINTHA KOMMADINNE 8.43
CHINTHA KOMMADINNE 5.48
KOTANANDURU 18.82
MADAKASIRA 2.20
VEERULLAPADU 13.22
ZAFERGADH 11.60
CHINTHA KOMMADINNE 21.72
MADAKASIRA 1.27
CHINTHA KOMMADINNE 9.40

In this table i want to the repeated Chintha Kommadinne down time values

i.e.chintha kommadinne repeated 4 times add the corresponding down time values(Chintha kommadinne =8.43+5.48+21.72+9.40

 

[WhoCanDo]

Do you have the name & number in separate columns and where do you want the result?

 

[T. Valko]

Hi,

I want to add the repeated entries values.can u help on this

Ex:

Element down time
CHINTHA KOMMADINNE 8.43
CHINTHA KOMMADINNE 5.48
KOTANANDURU 18.82
MADAKASIRA 2.20
VEERULLAPADU 13.22
ZAFERGADH 11.60
CHINTHA KOMMADINNE 21.72
MADAKASIRA 1.27
CHINTHA KOMMADINNE 9.40

In this table i want to the repeated Chintha Kommadinne down time values

i.e.chintha kommadinne repeated 4 times add the corresponding down time values(Chintha kommadinne =8.43+5.48+21.72+9.40

Maybe this...

Book1
	A	B	C	D	E
2	CHINTHA KOMMADINNE	8.43	_	CHINTHA KOMMADINNE	45.03
3	CHINTHA KOMMADINNE	5.48	_	KOTANANDURU	18.82
4	KOTANANDURU	18.82	_	MADAKASIRA	3.47
5	MADAKASIRA	2.20	_	VEERULLAPADU	13.22
6	VEERULLAPADU	13.22	_	ZAFERGADH	11.60
7	ZAFERGADH	11.60	_	_	_
8	CHINTHA KOMMADINNE	21.72	_	_	_
9	MADAKASIRA	1.27	_	_	_
10	CHINTHA KOMMADINNE	9.40	_	_	_
Sheet1

This formula entered in E2 and copied down:

=SUMIF(A$2:A$10,D2,B$2:B$10)