Try this:

=COUNTIF(Lineup!B$2:B$83,B9)

Hope this helps.

Pete

On Dec 1, 8:15 pm, bob wrote:
For every occurrence of a string in B9 in the current worksheet, I want to
count the number of cells that contain the letter W in Lineup Worksheet
F2:F83, where the string in Lineup Worksheet B2:B83 matches the string in B9.

I have tried using this formula but it counts all of the values in F2:F83; I
only want a count of those contaiing W.

=COUNT(IF($B9='Lineup Worksheet'!$B$2:$B$83,IF('Lineup
Worksheet'!$F$2:$F$83="W",0,0)))

Thanks,
Bob