If statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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?
 
=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...
 
untested but should be simple if statement
=if(C14="N",SUMIF(O20:O33,"Vacation",N20:N33) ,"")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with sum if function 1
help with sum if function 6
IF statement inside a SUMIF statement.... or alternative method 3
if then statement based on another column 6
SUMIF date criteria 3
Nesting SUMIF with Wildcard 3
Why doesn't this work ? 2
SUMIF data that falls within a range 3

Back
Top