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
--
grizz


"grizzly6969" wrote:

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
--
grizz