I have a database which lists addresses by city, state, zip. I have used
=COUNTIF(Database!H3:H33,"<A3""1") to count the number of times I see five
specific states appear (ID,UT,OR,NV,WA) BUT I now need to calculate the rest
of the states as "Other States". Must I list every other state abbrev.?