Count if cell has name and checkbox not checked
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
Answers
-
Try this...
=COUNTIFS(Name:Name, @cell = "John Doe", Checkbox:Checkbox, @cell <> 1)
-
Thanks for the fast response. Will this work if I need to count the information from another sheet?
-
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
-
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}
-
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'.
-
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
-
Happy to help. 👍️
-
Hi Paul,
How can I get in touch with you to do some contract work? Thanks
James
-
@James Teague Please feel free to reach out to me at
paul.newcome@thinkspi.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!