COUNTIF with nested String Extraction

  • Thread starter Thread starter tylerw
  • Start date Start date
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
 
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...
 
Back
Top