Formula to Count and Show Remaining if a certain image is placed in a separate column
In the screenshot below, I want to individually count how many England, Scotland and Wales are in the COUNTRY column, which I have done below.
But what I would like to do is subtract every time I insert a Sucessful.png image in the Key column so it shows me the remaining countries that still require a Sucessful.png image.
Hopefully that made sense.
Best Answer
-
Try:
=COUNTIFS(country:country, @cell="England", key:key, @cell <> "successful.png")
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Try:
=COUNTIFS(country:country, @cell="England", key:key, @cell <> "successful.png")
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Cheers Mark - You are a superstar :-)
-
Hi Dean, Happy to help. Glad you found a solution. Thank you for contributing to the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
Check out the Formula Handbook template!