Anyone know how I can combine the following three formulae, all of which provide me with the correct outcome on their own, into one?
=COUNTIF(INDIRECT($E$17),SUBSTITUTE(G16,"O","A~*"))
=COUNTIF(INDIRECT($E$17),SUBSTITUTE(G16,"O","A~*/A"))
=COUNTIF(INDIRECT($E$17),SUBSTITUTE(G16,"O","A")
E17 references a named range containing a series of values in the format A*, A*/A or A. I have tried concatenating the SUBSTITUTE section with the OR operator, but it's giving a 0 result, which is incorrect.
If anyone can spot immediately how to do this, I'd be grateful, otherwise if necessary I'll attach a file, but it will take some time to do that.
Bookmarks