• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SUMIFS not working

PaulaBidiman

New Member
This is my formula. I cannot get this to work for anything. Am I maybe using the wrong function?

77069
 

Attachments

  • sample book for Chandoo.xlsx
    58.8 KB · Views: 2
PaulaBidiman
This part cannot be correct Screenshot 2021-11-26 at 20.47.04.png there is not correct syntax.
as well as the last part which starts same way.
... I didn't check if "full-time"/"part-time" parts needs to be same as in Your sheet.
 
oK. So, I tried this and it gives me a spill error. =IF($C:$C="FULL-TIME",('Labor Related Expenses_Actual'!L4:L7)/('Labor Related Expenses_Actual'!L59),('Labor Related Expenses_Actual'!L6/'Labor Related Expenses_Actual'!L58))
 
Yes. That is what I have tried also and it still gives me a spill error. How did you not get a spill error? Do you know how I can get rid of it? I tried googling it but this spill is very new to me and it just doesn't make sense.
 
Back
Top