Combined IF Statement Question

[Cindi]

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?

 

[מיכ×ל (מיקי) ×בידן]

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]

Great! Thanks!
--
Cindi H

=SUMIF(A3:A9,"No",B3:B39)
--
David Biddulph




.