COUNTIF formula help

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

Answers

  • Kyrstie
    Options

    Hi,

    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

    Kyrstie

  • Purnima Gore
    Purnima Gore ✭✭✭✭✭✭
    Options

    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

    Purnima Gore

    Cierr Limited

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

    https://www.cierr.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!