Solved

Count Number of Instances In A Column In Excel

Posted on 2014-11-20
4
151 Views
Last Modified: 2014-11-20
Hey Experts,

My question is the following.  I am working on an excel worksheet in Excel 2013.  It is a collection of contact information, name, address, etc.  The address includes the State field in a column (Arizona, California, New York, etc.)  I can filter the data and determine the number of records that are in California.  This is a time consuming process if I need to go through all 50 states.  Wondering if their is a quicker way to perform this thru Excel without any extensive programming?
0
Comment
Question by:idejjedi2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 26

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40455219
put all unique states in a range lets say in another sheet2 starting from A1 then use countif

=countif(therangeofyourcolumninSheet1 , A1)  then copy the formula and drag down. so you will get the count for each states
0
 
LVL 70

Expert Comment

by:Qlemo
ID: 40455225
You can add a column with "=countif(StateColumn, StateColumnCell)" and dragging it down. Of course you cannot sum that column ;-).
0
 

Author Closing Comment

by:idejjedi2
ID: 40455322
Thanks Professorjimjam.  That worked well.   I do not ask many questions.  One last follow up - if not too much trouble.  How do the points get assigned?  I saw that the 500 points was stated for this question.  Is that a large amount, a small amount?  Is their a link on Experts Exchange that will answer my basic questions on how the point system works and the protocols?  Thanks again...
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question