Using Formula for a total count/sum

Thank you for taking my question.

What is the format to create a formula that supports this scenario; A total count or sum based on a specific word in a cell in a sheet.

For example, collect the total number of the word "Pass". Same for "Fail" and so on.


Tags:

Best Answer

  • Zachary Hall
    Zachary Hall ✭✭✭✭✭✭
    Answer ✓

    You would be able to pull it with:

    • =COUNTIF([Result Grade]:[Result Grade], CONTAINS("Pass",@cell))

    or

    • =COUNTIF([Result Grade]:[Result Grade], HAS(@cell,"Pass"))

    The difference being that the first would count if there were a text string like "Partially Pass", and the second will only pull if the string is solely "Pass".

    I hope this helps!

    Best,

    Zach Hall

    Training Delivery Manager / Charter Communications

Answers

  • Zachary Hall
    Zachary Hall ✭✭✭✭✭✭
    Answer ✓

    You would be able to pull it with:

    • =COUNTIF([Result Grade]:[Result Grade], CONTAINS("Pass",@cell))

    or

    • =COUNTIF([Result Grade]:[Result Grade], HAS(@cell,"Pass"))

    The difference being that the first would count if there were a text string like "Partially Pass", and the second will only pull if the string is solely "Pass".

    I hope this helps!

    Best,

    Zach Hall

    Training Delivery Manager / Charter Communications

  • YES!!! You have saved the day @Zachary Hall

    Thank you for the prompt response and the 2 options, very helpful! I'm able to successfully provide an accurate report.

    KLH

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!