help with sum if function

B

bl_johnson_19

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

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

Elkar

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
 
Top