Try this:

=SUMIF(A1:A100,"team ID",B1:B100)

Better to use a cell to hold the criteria:

D1 = team ID

=SUMIF(A1:A100,D1,B1:B100)

--
Biff
Microsoft Excel MVP


"Excel Sum function with IF" <Excel Sum function with
wrote in message
...
I am trying to figure out how to add all dollars amounts in other worksheet
under same team ID...for instance, there are 100 different team ID but
there
are some same Team ID. I want to add all values under the same Team ID.
I
don't want to sort the Team ID then do sum every time. I want to be able
to
type in data without having to sort it and update the function in other
sheet. How do I do that?