Reply
Highlighted
Regular Visitor
Posts: 22
Registered: ‎02-03-2016

Count of occurences within a row

I was wondering is there a function that could calculate number of occurences within one row? 

For example, i want to calculate the number of times word "red" occures within a row.

 

Result would look something like this:

 

 

     Color                |  Red  |  Blue

------------------------------------

 Red, Blue, Red      |   2     |  1

------------------------------------

  Red, Red, Red      |    3    |   0

 

Thanks