Hello:
I would like to count how many times a cell in the range q3:q13 starts with 'R'. Is this possible to do with countifs? (I'm using countifs because I want to filter the data more). I was thinking of using the search() function, but I do not believe that this function is compatible with countifs. Do I have to use sumproduct?
I understand that this doesn't work, but this is what I'm trying to accomplish: =countifs(c3:c13,$A3,q3:q13,search("r",q3:q13))
Thank you.
Adam
Bookmarks