I have a workbook with two sheets:

Sheet1!A:A contains unique text string values
Sheet2!A:A contains multiple instances of Sheet1!A:A values
Sheet2!B:B contains some cells with text string values and some with empty cells

In Sheet1!B2, I would like to use a formula that would count the number of non-blank cells in Sheet2!B:B in the rows where Sheet1!A2 matches Sheet2!A:A.

Thanks!