Hello all,
I am trying to return the count a certain string in one column (A:A).
The only criteria is that column (A:A) must match the contents of whatever is in column B. Let's say we're looking at row 2:
So:
=COUNTIF(SHEET!A:A,B2)
This works fine, obviously, but what if I wanted to match B2 with anything in (A:A) that started with the contents of B2, even if it has additional text after it?
For example, I want to count instances of cells that start with 'BLUE', but in A:A we find the following values: 'BLUEcar', 'BLUEhouse', 'BLUEman'
I can't alter the data in column A and additionally, I won't be able to add an additional column that does =LEFT(A2,3) and then run the COUNTIF on that. Basically, if all has to be done within one formula.
Thank you.
Bookmarks