Count Number of Instances In A Column In Excel

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?

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...

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…

Introduction
While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful. I tested several solutions and share the results in this article as well as t…

The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the
Monte Carlo …

Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.
Rather than update each graph to point to a different set within a static set of data, t…