I have a worksheet with Employee Names in one column and # of points in another. There are multiple occurances of each employee and the list is unsorted. This list will be added to on a regular basis by adding the employee name and the # of points for that occurance. The person adding the data knows nothing of excel so they are only doing straight data entry. I would like to tally the points dynamically by employee in another worksheet so that the list doesn't need to be sorted. As the data entry clerk adds the employees and the points, the summarizing formula would tally up the points by employee. I have looked at sumif but it doesn't seem to fit. Does anyone have any suggestions?