View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default help with sum if function

You're got too many arguments in your IF statement. Perhaps you mean to
check if C14="N"? Also, the two ranges in your SUMIF function aren't the
same size. Try this:

=IF(C14="N",SUMIF(O20:O32,"Vacation",N20:N32),"")

HTH,
Elkar


"bl_johnson_19" wrote:

Can anyone see why this formual below will not work...

=IF(C14,"N",SUMIF(O20:O32,"Vacation",N20:N33),"")