help with sum if function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

=IF(C14,"N",SUMIF(O20:O32,"Vacation",N20:N33),"")
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement 2
help with sum if function 6
I have a complex formula where I need to build in a MAX function 4
How can I get around 30 argument limit of SUM function? 4
Average of difference between dates greater than zero 8
Sports summary sheet - think I put this in wrong place originally 1
Time sheet calculations 3
Sum on multiple columns with search criteria 6

Back
Top