ExcelBanter - help with sum if function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - help with sum if function (https://www.excelbanter.com/excel-worksheet-functions/154041-help-sum-if-function.html)

bl_johnson_19[_2_]

help with sum if function

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

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

Elkar

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

All times are GMT +1. The time now is 10:50 PM.