Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • 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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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