using countif on sheet 2

[grizzly6969]

I have several drop down menus on sheet 1 with employee names in column H
is there a formula I can use in sheet 2 that will only count individuals
-- for example =countif(H1:H100,"=John Doe") but draw the information from
sheet 1

 

[JBeaucaire]

On sheet2, use a formula like this perhaps:

=COUNTIF(Sheet1!H1:H100,"John Doe")

 

[grizzly6969]

I thought that would be the correct formula but it will not work. Does it
make a differance if all the names are selected from a drop down menu

 

[JBeaucaire]

No. The problem is most likely with the data. In a cell near one of your
"drop down" John Doe cells, enter the same name manually. Now compare them
with a simple formula:

=A1=B1

If they are completely identical, you will see TRUE. Frequently, people make
mistakes creating drop down lists and have trailing spaces in there that are
invisible.

 

[grizzly6969]

Yes I got the TRUE response soooo is there a way I can correct the problem
with the drop down

 

[grizzly6969]

Thanks JB -- I got it to work -- I just noticed sheet 1 name was change a
little and once I put the correct sheet in it worked fine -- again thanks

 

[JBeaucaire]

Glad to hear...told you, the formulas are the same, so it's the data layout
that usually is the culprit.

Your feedback is appreciated, click YES if this post helped you.