Combined IF Statement Question
 

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

Combined IF Statement Question
 

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

"Cindi" wrote in message
...
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

Combined IF Statement Question
 

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

Combined IF Statement Question
 

Great! Thanks!
--
Cindi H


"David Biddulph" wrote:

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

"Cindi" wrote in message
...
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


.