I have a worksheet that has 2 collumns. The first collumn is just the
numerical order of each person (survey data). So it's simply 1, 2, 3,
4, 5...etc. Nothing crazy.
The collomn next to it is the results of the survey. It's simple data
(.123, .456, .789). My problem is that each of the numerical orders has
quite a few data points. So number 1 may have 5-6 sets of data in the
2nd collumn. So it looks like this

1 .123
1 .342
1 .425
1 .345
2 .123
2 .654
2 .346
3 .264
3 .346

There are probably around 65,000 data points so I was not about to
manually go and sum them. Is there a way that I can sum the data in the
2nd collumn for each "group"? Thanks.


--
Buildscharacter
------------------------------------------------------------------------
Buildscharacter's Profile: http://www.excelforum.com/member.php...o&userid=28783
View this thread: http://www.excelforum.com/showthread...hreadid=484687