As English is not my mothers tongue I appolegize if I didn't understood your
question correctly.
If I did - try this:
http://img37.imageshack.us/img37/6084/nonamecj.png
Micky

"Cindi" wrote:

I'm trying to get a formula that if any one of the cells in A3:A9 are "No"
then add the corresponding B3:B9, if "Yes" then don't add. I have six
differenting connecting sum areas that all need to be combined in one
formula. How can I do this?
--
JustLearning