Count if cell has name and checkbox not checked

T. Allan Hammond

Hi everyone,

I would like to count if a cell has a certain name in it; only if the done checkbox is not checked. I have tried several formulas found online; without success.

I can find the name; and count the unchecked boxes. Just cannot seem to connect the two.

Thanks,

AL

Paul Newcome

Try this...

=COUNTIFS(Name:Name, @cell = "John Doe", Checkbox:Checkbox, @cell <> 1)

T. Allan Hammond

Thanks for the fast response. Will this work if I need to count the information from another sheet?

T. Allan Hammond

This is what the formula looks like

=COUNTIFS({2021 IR action_assigned to}, "Name", AND({IR action items_2021 DONE}, @cell <> 1)) Invalid data type.

This is in a metrics sheet if that helps.

AL

Paul Newcome

No. You do not need the AND function. It would look the same as the other formula but instead of

[Column Name]:[Column Name]

you would have

{Range Name}

T. Allan Hammond

Hi,

Starting to get somewhere.

With this:

=COUNTIFS({2021 IR action_assigned to}, ="Hammond", {IR action items_2021 DONE}, @cell <> 1)

It is coming back as "0"; however, there are 4 items in the metrics sheet that are not done by Hammond. I tried these at the end with same result: <1, 0, removed '@cell'.

T. Allan Hammond

Hi,

I managed to get it working. Here is formula I ended up using:

=COUNTIFS({2021 IR action_assigned to}, FIND("Hammond", @cell) > 0, {IR action items_2021 DONE}, 0)

Thanks for keeping me focused on this and pointing me in the right direction.

Cheers,

AL

Paul Newcome

Happy to help. 👍️

James Teague

Hi Paul,

How can I get in touch with you to do some contract work? Thanks

James

Paul Newcome

@James Teague Please feel free to reach out to me at

paul.newcome@thinkspi.com