Solved

Excel 2010:  Count

Posted on 2013-06-20
4
438 Views
Last Modified: 2013-06-20
Hi Experts!  I need a formula that will count how many times a name appears in column A.  For example after I sort that column from A to Z i need to get a count of hown many times that username appears.   I could do this manually but that column is about 2000 rows, it would take forever.

JDOE
JDOE
JDOE
         3 imes

Thank you.
0
Comment
Question by:itsmevic
4 Comments
 
LVL 23

Assisted Solution

by:NBVC
NBVC earned 175 total points
ID: 39263696
Do you want a count in an adjacent column using a formula like:

=COUNTIF(A:A,A1) copied down

If you want a count below each name after sorting, you can use SUBTOTALS from the Data Menu.. select Count at the Use Function field.. ensure correct column is selected at the top and check same column in the bottom section...

If you want a table of all names and counts separately, you can use a Pivot Table... Insert|Pivot table, then drag the name to the Row area, and the Name again to the Summation area... it should give count of each name.
0
 
LVL 25

Assisted Solution

by:Ron Malmstead
Ron Malmstead earned 165 total points
ID: 39263698
=COUNTIF(A1:A2000,"JDOE")
0
 

Assisted Solution

by:mrbcam21
mrbcam21 earned 110 total points
ID: 39263725
=COUNTIF(A:A,"JDOE")
0
 
LVL 24

Accepted Solution

by:
Steve earned 50 total points
ID: 39263847
****  just read NB_VC after posting this one  ****
**** I agree with him that you should use pivot table  ****

Essentially same as NB_VC... (so no point for me on this one)
Add a column header (if not there already) such as UserName
Highlight data in A:A including header and go to Data > Pivot table
Click OK
Drag the UserName Field into the Row area and the Sum (sigma symbol) area.

You should now have the list of usernames in order and with a count next to each.
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

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
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…

713 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