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

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!