Counting Multiple columns using single criteria
 

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

Counting Multiple columns using single criteria
 

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

--
Biff
Microsoft Excel MVP


"Vikefan" wrote in message
...
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..