Use an array formula:

Assuming Probabilities are in column B and Bags are in Column C and that
there are only 10 rows of data.

=SUM(IF('B2:B11' 6, 'C2:C11', 0))

After you type that formula, hit Cntrl-Enter. Otherwise, it won't work.

Please let me know if you have any problems.

Mark

---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!