Forum Discussion

Copper Contributor

Dec 12, 2020

Formula not working for me

I am trying to get my spreadsheet to count how many zip codes that I have that are ">=" to a certain cell but "<=" another cell with the following formula and it is not working. =COUNTIFS(G2:G302...

Formulas and Functions

PeterBartholomew1

Silver Contributor

Dec 13, 2020

mehoop

The following

= LET(
  numeric,  VALUE(SUBSTITUTE(zip, "-", "")),
  filteredZIP, FILTER(zip, (numeric > startN) * (numeric <= endN) ),
  COUNTA(filteredZIP) )

would convert hyphenated zips to numbers and use the numeric values as a filter prior to counting.