:849240"},"body":"Is there a way of counting a specific word in a column but not count the word if it's in a coloured cell?","body@stringLength":"105","rawBody":"Is there a way of counting a specific word in a column but not count the word if it's in a coloured cell?
The below left table shows what our data looks like. By eye, we can see that there are a number of issues with it (below right), including missing data, zeros, negative numbers and text entries (all highlighted with coloured cells). Raw Data Raw Data with Highlighted Errors There might ...