COUNTA or Countif function??? Need help
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: COUNTA or Countif function??? Need help

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'd use a PivotTable.

  3. #3
    Guest

    Default

      
    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.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com