Avatar of idejjedi2
idejjedi2
 asked on

Count Number of Instances In A Column In Excel

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?
Microsoft Excel

Avatar of undefined
Last Comment
idejjedi2

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Professor J

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Qlemo

You can add a column with "=countif(StateColumn, StateColumnCell)" and dragging it down. Of course you cannot sum that column ;-).
idejjedi2

ASKER
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...
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes