• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

Excel 2013 Sum the number of times a name is added

If I have Three sheets.  One called summary and one called Jan and one called feb

I would like to count how many times the name John Doe and jane Doe appears in the sheet Jan and FEB and sum it up in the sheet Summary.

I have attached a sheet as an example.

Is there a way to do this??

Thanks!!
Experts.xlsx
0
Curtis Long
Asked:
Curtis Long
4 Solutions
 
Dan CraciunIT ConsultantCommented:
See attached file.

HTH,
Dan
Experts-test1.xlsx
0
 
PowerEdgeTechIT ConsultantCommented:
You could use the following to search for and count instances of "John Doe" on the January sheet:

=COUNTIF(Jan!1:1048576,"John Doe")
0
 
andrew_manCommented:
Using Pivot Table
Experts.xlsx
0
 
Saqib Husain, SyedEngineerCommented:
Enter this formula in C2 and copy it down and across

=COUNTIF(INDIRECT("'"&C$1&"'!1:"&ROWS(A:A)),$A2)
0
 
Curtis LongAuthor Commented:
All outstanding answers!!

Thanks so much!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now