| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement
=SUMIF(O20:O33,"Vacation",N20:N33)
In the sumif statement above, I want to add to it. I'm trying to add if C14 equals "N" then do the rest of the sumif statement. any help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement
=if(c14="n",Yoursumifformula,"somethingelse")
bl_johnson_19 wrote: =SUMIF(O20:O33,"Vacation",N20:N33) In the sumif statement above, I want to add to it. I'm trying to add if C14 equals "N" then do the rest of the sumif statement. any help? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement
untested but should be simple if statement
=if(C14="N",SUMIF(O20:O33,"Vacation",N20:N33) ,"") -- -John Please rate when your question is answered to help us and others know what is helpful. "bl_johnson_19" wrote: =SUMIF(O20:O33,"Vacation",N20:N33) In the sumif statement above, I want to add to it. I'm trying to add if C14 equals "N" then do the rest of the sumif statement. any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| Possible IF statement? | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Linear Mode
