|2||02 Jan 2018||x||x||x, y||x||y||x|
|3||11 Jan 2018||x, z||x|
|4||24 Jan 2018||z||x||x||z||y|
|5||04 Feb 2018||x, y|
|6||15 Feb 2018||z||y||x, z||x||x, y|
|7||07 Mar 2018||x|
|8||16 Mar 2018||x||y, z||x||z|
|9||29 Mar 2018||x||x, z||y|
I could use some help to automate some simple data trending please, example above. I'd like to count the number of cells that contain a specific string of text, for a give date range, for a specific category.
For example, I'd like to find the number of times I've had a "x" result for any "Red" tests during January. So if any cell in column A contains a date in January, I'd like to count the number of corresponding cells in columns B, D and G that contain the text string "x", in this example = 3.
Annoyingly the spreadsheets are a bit of a mess, with dozens of non-contiguous columns of data, and multiple data entries in a single cell (e.g. "x, y, z" all as a string of text, separated by commas).
Any help would be greatly appreciated, thanks