Counting Duplicate Cells in different columns

Greetings,
I've been racking my brain for the longest time and I am trying to get something to work in excel but unfortunatley I can't figure it out and neither can my co-workers
I have 6 columns on 1 sheet that evenly divides my staff into seperate shifts. On another sheet I have 1 column that shows what individuals are qualified to perform certain tasks.
I would like to have a cell on my first sheet that compares that columns data with the list on the second sheet and return a number the number of people that are qualified for that shift.

EXAMPLE

Worksheet 1

Qual # (this is what I need to count from the second sheet)

Section 1 Section 2 Section 3 Section 4 Section 5

Bob Jason Kieth AL Cindy
Jill Mark John Sandy Bice
Sue Suzy Jody Karen Kevin
Frank Alen Mary Cathy Bill
Mike Angel Connie Lynn Marcos
Tom Larry Rebecca Megan Robert



Qualified

Mike
Alen
Sandy
Bill
Bob
Rebecca
Megan
Robert
Connie

As you can see all columns are in no particular order so I need each column on the first sheet to lookup every cell in a given column on the second sheet and output the number of qualified personnel.


Thank you so much in advance for any help. I've attached an .xls as my example if it is easier for anyone to explain to me how to get this done.

Very Respectfully,

Steve

Sort the list of Qualified people into alphabetic order.

Then...

In cell B5 enter

=COUNTIF(Qualification!A3:A11,B6)+COUNTIF(Qualification!A3:A11,B7)+COUNTIF(Qualification!A3:A11,B8)+COUNTIF(Qualification!A3:A11,B9)+COUNTIF(Qualification!A3:A11,B10)+COUNTIF(Qualification!A3:A11,B11)

In cell D5 enter

=COUNTIF(Qualification!A3:A11,D6)+COUNTIF(Qualification!A3:A11,D7)+COUNTIF(Qualification!A3:A11,D8)+COUNTIF(Qualification!A3:A11,D9)+COUNTIF(Qualification!A3:A11,D10)+COUNTIF(Qualification!A3:A11,D11)

In cell F5 enter

=COUNTIF(Qualification!A3:A11,F6)+COUNTIF(Qualification!A3:A11,F7)+COUNTIF(Qualification!A3:A11,F8)+COUNTIF(Qualification!A3:A11,F9)+COUNTIF(Qualification!A3:A11,F10)+COUNTIF(Qualification!A3:A11,F11)

In cell H5 enter

=COUNTIF(Qualification!A3:A11,H6)+COUNTIF(Qualification!A3:A11,H7)+COUNTIF(Qualification!A3:A11,H8)+COUNTIF(Qualification!A3:A11,H9)+COUNTIF(Qualification!A3:A11,H10)+COUNTIF(Qualification!A3:A11,H11)


In cell J5 enter

=COUNTIF(Qualification!A3:A11,J6)+COUNTIF(Qualification!A3:A11,J7)+COUNTIF(Qualification!A3:A11,J8)+COUNTIF(Qualification!A3:A11,J9)+COUNTIF(Qualification!A3:A11,J10)+COUNTIF(Qualification!A3:A11,J11)

This should count the number of people in columns B D F H J who are in the Qualification list

Special-K,
Thank you for the prompt response. Not quite what I'm looking for but close.

The .xls that is attached is extremely basic to what I am actually working with. The sheet that I'm working with has the names of my ship's crew (Navy) and I really didn't want to post that.

The Sections list has six sections and approxiametly 40 people in each section. On the qualifications page there could be 100+ personnel that would be qualified for a particular job. On the qualifications page it is already sorted by alphabetical order. There will be multiple qualifications to compare but once I can get one working I can figure out the rest by changing the different cell references.

So I'm looking for something a little more complex that would compare mulitple cells at one vice individually doing it like that.

Any other suggestions?