Is there any way to nest text operators within a countif?
I want to check if the first 4 characters of a file are in the form A**
.
=Countif(Left(A1,4),"A??.") doesn't work, but I can put in a
=Left(a1,4)
column and then do
=Countif(B1,"A??.") no problem.
Any way around this? Normally I would just use if, but it doesn't accept wildcards.