How to count occurence of names on Excel?

Asked By Jimmy L Merrick 60 points N/A Posted on - 04/03/2015

I'm currently preparing my project plan and I'm on the references section. Here, I need to calculate the occurrence of each name on the whole sheet. I cannot locate a function that meets my demands so I would like you to support me with this. 

How can I count the occurrences of names on a sheet?

• Status: Open
• Question Views: 587
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Dave Crinit 5 points N/A #180714

How to count occurence of names on Excel?

Happy to support you!

 

There are 3 alternatives to choose from,

• NOTE: All these formulae must be entered as array formulae. To enter an array formula, press CTRL+SHIFT+ENTER. 

 

 

Method 1»

 

Use the COUNTIF() function to count the occurrences of a text string. For example, use the formula

=COUNTIF(range,"text")

 

Here range means the range of cells that you are evaluating, and text is the text string that you want to count instances of (note that text must be enclosed in quotation marks). 

 

Example-

 

 

 

 

Method 2»

 

=SUM(IF(range="text",1,0))

 

Method 3»

 

=SUM(LEN(<range>)-LEN(SUBSTITUTE(<range>,"text","")))/LEN("text")

 

About Dave Crinit

Questions
0

Answers
211

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 04/03/2015
• Question Category: MS Excel