Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Can I use Countif with multiple criteria in one cell

    ✭✭
    edited 05/14/24 in Formulas and Functions

    Hello would it be possible to use the Countif statement when there are multiple items in a cell. See below for further information

    Here is the column that has multiple items in each Cell

    image.png

    I need to get individual counts of those items to then be populated into the sheet below

    image.png
    Tags:
    · Share on FacebookShare on Twitter

    Answers

    • Community Champion
      edited 05/14/24

      =COUNTIF({Items Ref}, CONTAINS([Items Recovered]@row, @cell))

      image.png

      If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

      · Share on FacebookShare on Twitter
    • ✭✭

      How would I do this if I am reference another sheet for the count?

      Here is what I was toying with

      image.png
      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions