Countif Question....!!!

[gymwrecker]

I have the following:

Worksheet 1

A1=Mr. John Doe
A2=Mrs. Jane Doe
A3=Mrs. Jane A. Doe
A4=Mr. John Doe

Note: In each of these cells (A1:A4) I'm using a Data Validation list (drop-down meny) including the names above.

Worksheet 2

The formula in A1 must count how many times Mr. John Done repeats within the range. A2, the same formula, but for Mrs. Jane Doe.

Any advice?

Thanks!

 

[Yogi Anand]

Hi Gymwrecker:

Let me see if I have understood you correctly ...

Book1
	A	B	C	D
1	Mr. John Doe
2	Mrs. Jane Doe
3	Mrs. Jane A. Doe
4	Mr. John Doe
5	Mr. John Doe
6	Mrs. Jane Doe
7	Mrs. Jane A. Doe
8	Mr. John Doe
Sheet1

Then Sheet2 ...

Book1
	A	B	C	D
1	Name	Count
2	Mr. John Doe	4
3	Mrs. Jane Doe	2
4
Sheet2

formula in cell B2 is ... =COUNTIF(Sheet1!$A$1:$A$8,Sheet2!A2)

this is then copied down.

 

[gymwrecker]

Got it. It's working perfect.

Thanks for the help!!!!

 

[Peter_SSs]

A small point, but since the formula is on Sheet2, the reference to Sheet2 in the formula should not be needed. That is, this should do the same job:
=COUNTIF(Sheet1!$A$1:$A$8,A2)