COUNTIF formula help

This discussion was created from comments split from: COUNTIF EXCEPT.


  • Kyrstie


    I'm working on converting qualitative data into quantitative figures which are also dependent on whether there was a positive or negative closed answer. However, there are a couple of positive answers with partial negative responses. I need to do a countifs that captures a specific answer in one column and disregards a specific phrase in another column!

    Any help will be greatly appreciated


  • Purnima Gore
    Purnima Gore ✭✭✭✭✭✭

    Hi @Kyrstie

    Are you able to show give me an example please here so that I can see what you are after?

    I have a number of If Statements that I have used and you may be able to use that structure.

    Kind regards


    Purnima Gore

    Cierr Limited

    Your Time is Important, you want to Stay on Track, We can help you use the Right Tools

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!