COUNTIFS

[John Stout Sr]

I need to count the number of NET check ins by state using initials:
ie: BIRMINGHAM,AL I need to the number of ",AL" (comma must be considered) in a column of 30 or 40 towns in Alabama.
In MS Excel it looked like this:
=COUNTIFS($B$6:$B$386,"*,*AL*", $H$6:$H$386,">0")
Any help.

[John Stout Sr]

lAYOUT IS IN SPREADSHEET. EACH GROUP ARE IN COLUMNS;
THE SEARCH IS FOR OVER 300 ROWS AND MANY STATES;
I CAN SET A "SPACE" BETWEEN THE COMMA IF NECESSARY, WASN'T NEEDED IN EXCEL

ALABAMA 0 0
50% BIRMINGHAM,AL KI4VKK JIM
36% BOAZ,AL W4AUE LARRY
38% CHATOM,AL KN4FSZ RICKY
ARKANSAS 0 0
19% ARKADELPHIA,AR KE5VLX CHUCK
12% CAVE CITY,AR KE5YQK JOHNNY
63% CONWAY,AR AE5GH GERALD
70% FORT SMITH,AR KC5UPE AL
FLORIDA 0 0
24% COTTONDALE,FL KI4EU WINFORD
18% DE FUNIAK SPRINGS,FL K4NDJ ROY
11% DUNNELLON,FL KM4FKN CHARLES
GEORGIA 0 0
10% CALHOUN,GA KG4KXI JEFF
16% CARROLLTON,GA KE4OBE MIKE
33% EASTMAN,GA KM4VCF TERI
37% FAYETTEVILLE,GA KI4NGD HUEY
91% HARTWELL,GA WB4BIK SAM
48% LAWRENCEVILLE,GA AB4OK LIGE
47% MABLETON,GA W4VBP BOYCE
32% MCDONOUGH,GA W4NOC KEN
13% ROOPVILLE,GA KK4CTV CHARLES
INDIANA 0 0
12% ANDERSON,IN W6OYW TERRY
IOWA 0 0
72% FORT MADISON,IA KA0QIQ DICK
KANSAS 0 0
60% WICHITA,KS N0RAB ROLAND

[Villeroy]

Install https://libreoffice.org/ and enable wildcard matching.

[keme]

Try search term ",AL\>"
The "\>" token means "end of word".