| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SQL statement question | Excel Discussion (Misc queries) | |||
| If then statement question.... | New Users to Excel | |||
| If statement question | Excel Discussion (Misc queries) | |||
| IF then statement question | Excel Discussion (Misc queries) | |||
| Combined IF statement... | Excel Worksheet Functions | |||
Hybrid Mode
