I need a formula that will allow me to count the non blank cells in a
separate worksheet that match the criteria in the work sheet that I'm
summarizing on. For instance if I need to locate the number of employes in
dept "1" that have been scored on a test thats included in a separate work
sheet in the same file. the data sheet includes the dept in one column and
the score results in a separate column on the same sheet. the fomula should
return the amount of employees in a particular dept(ciiteria) on the sheet
and then how many of them have been scored..

Can you post some sample data and tell us what result you expect?

--
Biff
Microsoft Excel MVP


"Vikefan" <(E-Mail Removed)> wrote in message
news:4A85D13F-5434-4DB7-9F13-(E-Mail Removed)...
>I need a formula that will allow me to count the non blank cells in a
> separate worksheet that match the criteria in the work sheet that I'm
> summarizing on. For instance if I need to locate the number of employes in
> dept "1" that have been scored on a test thats included in a separate work
> sheet in the same file. the data sheet includes the dept in one column and
> the score results in a separate column on the same sheet. the fomula
> should
> return the amount of employees in a particular dept(ciiteria) on the sheet
> and then how many of them have been scored..