Hi Scott
Try this =SUMIF(A2:5,"JG",B2:B5)
HTH
John
"Scott A" wrote in message
...
Hello,

I am trying to sun up all of the costs in one column if it was done by a
specific person.

Example:

A B
Prsn Contracts
1 JG $8000.00
2 JG $1200.00
3 SA $10000.00
4 TS $6000.00
5 TS $4500.00

What I am looking for is a formula that will tell me how much is the total
value of all of the contracts sold by JG.

Can anyone help?