View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott A[_2_] Scott A[_2_] is offline
external usenet poster
 
Posts: 57
Default CountIF and Sum in one formula?

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?