Take a look at SUMIF() in Help.

In article ,
JerryS wrote:

I have two comumns. The first has the rep initials. The second has a value. I
would like to total the value for each rep. Any suggestions? Thanks