I have a column in google spreadsheet name `domains` which contains the array of values like `['non work', 'work', 'work', 'non work']`, is there a way to find the count within that column which equals to `work` Below is the screenshot of what I want to achieve. [![enter image description here][1]][1] [1]: https://i.sstatic.net/Ki9nf.png In `Work Domain Count` column values should be respectively 3, 2 and 0