COUNTA or Countif function??? Need help

mxstanl · Mar 4th, 2002, 02:44 PM

I have a list of 2000 addresses. City, state, and Zip. I want to count how many of each exist in the sheet. Column A contains city. I want the results to return the number of occurances of each city. Can someone map out the syntax for me? THanks,
Mark

Mark W. · Mar 4th, 2002, 02:47 PM

I'd use a PivotTable.

Mar 4th, 2002, 02:54 PM

You could use the Countif function, and Excel will step you right through it. It would be something like =COUNTIF(A1:A2000,"City Name"). But you would have to do that separately for each city. Faster way would be to sort it by your city column, and then do subtotals. That would give you subtotals for each city.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 02:44 PM	#1
mxstanl New Member Join Date: Mar 2002 Posts: 1	I have a list of 2000 addresses. City, state, and Zip. I want to count how many of each exist in the sheet. Column A contains city. I want the results to return the number of occurances of each city. Can someone map out the syntax for me? THanks, Mark

Mar 4th, 2002, 02:47 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	I'd use a PivotTable.

Mar 4th, 2002, 02:54 PM	#3
Guest Posts: n/a	You could use the Countif function, and Excel will step you right through it. It would be something like =COUNTIF(A1:A2000,"City Name"). But you would have to do that separately for each city. Faster way would be to sort it by your city column, and then do subtotals. That would give you subtotals for each city.