If statement

B

bl_johnson_19

=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?
 
D

Dave Peterson

=if(c14="n",Yoursumifformula,"somethingelse")



bl_johnson_19 said:
=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?
Click to expand...
 
J

John Bundy

untested but should be simple if statement
=if(C14="N",SUMIF(O20:O33,"Vacation",N20:N33) ,"")
 
Top