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),"")
|