Hi
I wonder if anyone can help, or if this is even possible?!

I want to use the COUNTIF function to count the number of cells containing a certain TEXT. However, if the text value then changes, I want the count to stop, even if the same text value appears again.

For example, let's say I have 5 columns containing the word "HELLO", then 1 column which contains the word "GOODBYE", and then another column which contains "HELLO" again. Normally, across the whole range of columns, the value would be 6. However, I want to return 5.

Is this possible?!

Best wishes.