Formula for a group selection

Dee Barnard
Dee Barnard ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I want to count the number of items when their description contains a certain word.  

Count if Description contains the word "grey".  There would be multiple descriptions with the word GREY in the column. Ex. Dark Grey, Grey Mist, Green Grey, Blue Grey. I want a total for all items that are GREY.

Is this possible? Other software would you let you put a * to indicate that this is a partial name search.

Tags:

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    =COUNTIFS([Color Column Name]:[Color Column Name], FIND("grey", LOWER(@cell)) > 0)

     

    Give this a try and see if that works for you.

    thinkspi.com