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
Curtis LongAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Dan CraciunConnect With a Mentor IT ConsultantCommented:
See attached file.

HTH,
Dan
Experts-test1.xlsx
0
 
PowerEdgeTechConnect With a Mentor IT 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_manConnect With a Mentor Commented:
Using Pivot Table
Experts.xlsx
0
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
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
All Courses

From novice to tech pro — start learning today.