Summing Raw data

**meprarth** · 06-29-2010, 02:53 AM

I have a list of numbersnames with varying values.
I want to sum all the values with aassociated with particalular name

HOw can i do that

**DonkeyOte** · 06-29-2010, 03:06 AM

see SUMIF in XL Help... also consider using a Pivot Table - see link in sig. for general introduction.

If you need more detailed help provide a more detailed question - generally speaking "you get out what you put in" on the board.

**meprarth** · 06-29-2010, 05:57 AM

hmm.. this is the data i have
Local Cell ID No. of Leakage Events
101431033 1
104663261 1
102029831 4
11011111 1
21159293 1
135045171 1
21224063 1
127746091 1
401221262 1
401221273 1
404341311 1
101827522 1
101827523 1
104040023 1
21808101 1
10919153 1
102828703 1
401856502 1
401856803 1
401858023 1
101927623 1
10616482 1
21159022 1
104040042 1
104040113 1
401856583 1
100211222 1
101625172 1
200330073 1
101431681 1
103534142 1
104848361 1
101431073 1
10313221 1
13320761 1
13320761 1
13320772 1
104663423 1
401523893 1
104343711 1
135045381 2
20453062 1
104444052 1
104444423 1
401221852 1
21159132 1
401222883 1
100110093 1
100110452 1
100211362 1
101725993 1
401856731 2
60050191 1
103131142 1
103131292 1
104161381 1
104562391 1
104848621 1
401523853 1
401524131 1
401524143 1
401524291 1
401658372 1
401658392 1
401658532 1
401658752 1
401659232 1
401220011 1
401221881 1
401222221 1
401856203 1
401856572 1
401856591 1
401524641 1
401658373 1
10616201 1
101431243 1
401658212 1
401658372 1
60160393 1
402757501 1
104444093 1
127746023 1

how do i sum the values in leakage column for cells with same ids