MS Excel: Use an array formula to count the number of rows that ...

In Microsoft Excel 2003/XP/2000/97, I have a workbook with 2 sheets: Sheet1 has 0-to-many rows for one city (one row for each case opened in that city).

www.techonthenet.com