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

-----Original Message-----
One way is to use "helper columns". It's not pretty in
some ways, but it's
easy to do and easy to track if you've got errors.

Assuming your example columns are A, B, C, and D,
starting with headers in
row 1, in E2 put =IF(B26,C2, ""), and in F2 put =IF
(B26,D2, ""). Run
these down to the bottom of your range. At the botom of
Column C, put
=SUM(E2:Exxx) (where xxx is the number of the last row).
The bottom of
Column D would have =SUM (F2:Fxxx).

Hope this helps.
Ed


"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


.