Thanks so much, this is exactly what i needed to do.

-----Original Message-----
Kim

=SUMIF($B$2:$B$4,"6",C2:C4)
and
=SUMIF($B$2:$B$4,"6",D2:D4)

assuming that the probability is in column B, and the bag
count and contract
amounts are in columns C and D respectively.

Regards

Trevor


"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


.