The formula in Column D should lookup the name in Column C, go to Column A
and find the corresponding name(s), then count the number of percents
opposite the corresponding name in Column B that are less than 90%. (I did a
manual count in Column D as illustration of what the final result should look
like.) Thanks !!!

Column A Column B Column C Column D (Formula
column)
Name Percent earnings Criteria Count
SMITH K 106% SMITH T 2
SMITH T 101% SMITH K
CHILDERS 97% ANDERSON 1
SMITH T 92% NEWTON
SMITH T 87% LEVINE 1
SMITH T 76% HOGAN
SMITH T 102% CHRISTOS
LEVINE 60% CHILDS
SMITH T 100% CATALDY
ANDERSON 77% BAKERS