Please pardon the reposting, my original got a lot of discussion, masking the
lack of a final solution.

On sheet1 I have a column with multiple names. I need a function (in one
cell, on a separate sheet) that can look up all those names from column B of
sheet2, and then count the occurance of a value in column H of those same
rows in sheet2. Here's the example:

Sheet1 (note that some rows are blank, and some names may appear 1 time):
Helen Back
Cyndi Lou Who


Cyndi Lou Who


Sam Spade

Sheet2 (names only appear once):
col B col H
Cyndi Lou Who R2
Dan Danger R1
Dou Luva R3
Hal Brook R2
Helen Back R1
Joe Mama R2
Lou Duva R2
Mai Tai R2
Roberta Flack R3
Ron Popeil R2
Sam Spade R2
Will Not R2
Yoda n/a

So I need a single formula that can lookup sheet1's names (in this case,
four of them) in col B of sheet2, then give me a count of all corresponding
values "<R1" in col H. If names are repeated in sheet1, I do need to
include the multiple occurences in my count.

Thanks in advance for any ideas!