Assuming Job Name is in A1 . . .
In C5 =SUMIF($B$2:$B$4,"6",C2:C4)
In D5 =SUMIF($B$2:$B$4,"6",D2:D4)

B2:B4 is the range of the probabilities
C2:C4 & D2:D4 is the range to be summed

Dan E

"Kim" wrote in message
...
I need a formula that will allow me to add amounts in two
separate columns, but only the amounts that have a certain
variable in another column. I will try to make an example
below.

Job Name Probability Bag Count Contract Amount
School 10 100 $100.00
Gym 5 500 $5000.00
Pool 7 200 $2000.00

OK, I need to add up the Bag count and the Contract
amounts at the bottom of each column, but only the ones
with a probability above 6. Is there a formula that can
be that specific?

Thanks in advance,
Kim