Trying to use COUNTIFS with checkboxs

Suzy Holmes

I have been trying to build this from the ground up to try and figure out what I am doing wrong. This seems like it should be easy, but the formula returns "Unparsable".

My formula is: =COUNTIFS([Task Name]:[Task Name], "SMB", [Done:Done], 1)

In english, this should mean if a task name is equal to SMB and the done checkbox is checked, please count.

If I do a single action, it works just fine:

=COUNTIF([Task Name]:[Task Name], "SMB")

Please help me!

Deanna Vandermeer

Try your formula this way ...

=COUNTIFS([Task Name]:[Task Name], "SMB", Done:Done, 1)+""

Let me know if this works for you.

Deanna Vandermeer

Try your formula this way ...

=COUNTIFS([Task Name]:[Task Name], "SMB", Done:Done, 1)+""

Let me know if this works for you.

Suzy Holmes

First and foremost, thank you so much for replying so quickly!!!

Well, that got rid of the "Unparsable", but the answer is incorrect. What exactly does the +"" indicate?

Suzy Holmes

Actually, that did work, I had a typo! Thank you so much, but was does the +"" add to this?

Deanna Vandermeer

I am so happy that worked for you. Checkboxes have an expected value of 0 or 1, but by adding the +"" to the end of the formula you are ensuring that it will show the result. In this case you are asking for it to return a count of all the checkmarks (the 1s in this case). I hope this makes sense and again, I am happy it worked for you. Please feel free to reach out anytime you need help, I love helping.