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