count a word twice if it appears in a cell twice

Options

Answers

  • KPH
    KPH ✭✭✭✭✭✭
    edited 09/02/22
    Options

    Does anyone know if it is possible to extend this to count a word twice if it appears in a cell twice?

    For Example:

    Column: Fruit

    Cell 1: Apples, Pears Bananas

    Cell 2: Apples, Pears, Apples

    Cell 3: Apples, Oranges, Bananas


    Summary:

    Apples: 4

    Pears: 2

    Bananas: 2

    Oranges: 1

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Options

    @KPH

    The below is an example formula:

    =COUNTIF(Fruits:Fruits, CONTAINS("Apples", @cell)) + COUNTIF(Fruits:Fruits, CONTAINS("SecondApples", SUBSTITUTE(@cell, "Apples", "SecondApples", 2)))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!