Really struggling with this one - I've tried variants of countif, sum and lens but can't get it to work....
I've got a spreadsheet with random data in the range F7:Z16.
In the cells is a mixture of numbers, letters and spaces.
What I want to do is to count across the whole range for the number of times a particular combination of letters is found e.g.
if the cell F7 contains "example text xxy", cell F8 contains "8", cell F9 is blank and cell F10 contains "different text xxy"
the answer returned to the above should be "2" as there are two cells that contain (amongst other things) the text "xxy".
Is this possible?
I've got a spreadsheet with random data in the range F7:Z16.
In the cells is a mixture of numbers, letters and spaces.
What I want to do is to count across the whole range for the number of times a particular combination of letters is found e.g.
if the cell F7 contains "example text xxy", cell F8 contains "8", cell F9 is blank and cell F10 contains "different text xxy"
the answer returned to the above should be "2" as there are two cells that contain (amongst other things) the text "xxy".
Is this possible?
