Macros/Visual Basic for Applications (VBA)

Insert two blank rows above the range, and copy and paste the column headings into the first blank row. In the second blank row, enter New York in the cell under the State field. In another cell outside the criteria range, enter =DCOUNTA(Type the range or named range. ................
................