=sumproduct((A1:A5="JG")*(B1:B5="MP"),C1:C5)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Scott A" wrote in message
...
I have another part that I totally forgot about. I have a second formula
that
is needed and it includes another variable. I need it to narrow the sum
total
to only projects of a certain type of contract by the same person.

example:

A B C
Prsn Type Contracts
1 JG MP $8000.00
2 JG DV $1200.00
3 JG MP $10000.00
4 SA MP $6000.00
5 SA DV $4500.00

I need it to calculate the total contract amount for JG and only the MP
types of contracts. Is that possible without using a pivot table?

"Shane Devenshire" wrote:

Hi,

Put JG in a cell, say H1 then use the formula

=SUMIF(A$2:A$6,H1,B$2:B$6)

This way you can copy the formula down so if H2 has "SA" then the second
formula sum his/her numbers and so on.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Scott A" wrote:

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?