Thread: If statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default 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?