Countif NOT working, returning 0...

[91709jack]

Hi all,

Here's the formula that's not working...

=COUNTIF(AK52:AK35533,CONCATENATE(T$4,U$4,"??16??m1"))

Stumped!

THANKS for your help!

Jack

 

[Aladin Akyurek]

But wait!

Say an AK cell contained TWO, or even 27 instances of substring "1?????1???m?" - will COUNTIF still work?

It will count that cell just once.

 

[91709jack]

It will count that cell just once.

So what should the formula look like to count EVERY instance?

 

[Aladin Akyurek]

So what should the formula look like to count EVERY instance?

I think this would require VBA.

 

[91709jack]

Oh well, I think I'll pass on VBAs. Was able to clean up and simplify and dropped from 16 sec to 10 sec to about 6 sec so good enough! Thanks again.

 

[Aladin Akyurek]

Oh well, I think I'll pass on VBAs. Was able to clean up and simplify and dropped from 16 sec to 10 sec to about 6 sec so good enough! Thanks again.

Great. Thanks for the update.