COUNTIF with nested String Extraction

T

tylerw

=COUNTIF($H$4:$H$65536,"BA-"RIGHT(O9,4)*)

The above is what I want to conceptually do but the syntax is no
correct. I need to COUNTIF based on "BA-[last four characters][wit
any character after that]. Every thing I try fails and I haven't bee
able to fin an answer to this on any website. Please help
 
D

Dave R.

sorry make that- had an extra * in there.

=+COUNTIF($H$4:$H$65536,"ba-"&RIGHT(O9,4)&"*")



Dan E said:
Tyler,

untested but try

"BA-" & RIGHT(O9,4) & "*"

Dan E


=COUNTIF($H$4:$H$65536,"BA-"RIGHT(O9,4)*)

The above is what I want to conceptually do but the syntax is not
correct. I need to COUNTIF based on "BA-[last four characters][with
any character after that]. Every thing I try fails and I haven't been
able to fin an answer to this on any website. Please help.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract characters from Right of string 5
Extracting text from right to left using MID and FIND 6
Is a Nested Formula what I need? 1
Extracting text from text string 3
count text strings in an entire workbook 1
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Formula to sum values extracted from string 10
How to extract portion of text 5

Top