software

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)
NamePercent earningsCriteria 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=SUMPRODUCT(--(A2:A11=C2),--(B2:B11lt;0.9))

You will need to change the formating to the following custom format to show
a blank instead of zeros

General;-General;

quot;Juana Cafequot; wrote:

gt; The formula in Column D should lookup the name in Column C, go to Column A
gt; and find the corresponding name(s), then count the number of percents
gt; opposite the corresponding name in Column B that are less than 90%. (I did a
gt; manual count in Column D as illustration of what the final result should look
gt; like.) Thanks !!!
gt;
gt; Column A Column B Column C Column D (Formula
gt; column)
gt; NamePercent earningsCriteria Count
gt; SMITH K 106% SMITH T 2
gt; SMITH T 101% SMITH K
gt; CHILDERS 97% ANDERSON 1
gt; SMITH T 92% NEWTON
gt; SMITH T 87% LEVINE 1
gt; SMITH T 76% HOGAN
gt; SMITH T 102% CHRISTOS
gt; LEVINE 60% CHILDS
gt; SMITH T 100% CATALDY
gt; ANDERSON 77% BAKERS
gt;

=sumproduct(--(A$1:A$1000=C2),--(B$1:B$1000lt;0.9))
Enter that in D2 to get the count for SMITH T, then copy down as many rows
as you need. Also, change the row range to cover your entire dataset
(sumproduct can't take entire columns as input, though you could use
$A$1:$A$65536 if necessary).

quot;Juana Cafequot; wrote:

gt; The formula in Column D should lookup the name in Column C, go to Column A
gt; and find the corresponding name(s), then count the number of percents
gt; opposite the corresponding name in Column B that are less than 90%. (I did a
gt; manual count in Column D as illustration of what the final result should look
gt; like.) Thanks !!!
gt;
gt; Column A Column B Column C Column D (Formula
gt; column)
gt; NamePercent earningsCriteria Count
gt; SMITH K 106% SMITH T 2
gt; SMITH T 101% SMITH K
gt; CHILDERS 97% ANDERSON 1
gt; SMITH T 92% NEWTON
gt; SMITH T 87% LEVINE 1
gt; SMITH T 76% HOGAN
gt; SMITH T 102% CHRISTOS
gt; LEVINE 60% CHILDS
gt; SMITH T 100% CATALDY
gt; ANDERSON 77% BAKERS
gt;

Thanks so much !!!

quot;Slothquot; wrote:

gt; =SUMPRODUCT(--(A2:A11=C2),--(B2:B11lt;0.9))
gt;
gt; You will need to change the formating to the following custom format to show
gt; a blank instead of zeros
gt;
gt; General;-General;
gt;
gt; quot;Juana Cafequot; wrote:
gt;
gt; gt; The formula in Column D should lookup the name in Column C, go to Column A
gt; gt; and find the corresponding name(s), then count the number of percents
gt; gt; opposite the corresponding name in Column B that are less than 90%. (I did a
gt; gt; manual count in Column D as illustration of what the final result should look
gt; gt; like.) Thanks !!!
gt; gt;
gt; gt; Column A Column B Column C Column D (Formula
gt; gt; column)
gt; gt; NamePercent earningsCriteria Count
gt; gt; SMITH K 106% SMITH T 2
gt; gt; SMITH T 101% SMITH K
gt; gt; CHILDERS 97% ANDERSON 1
gt; gt; SMITH T 92% NEWTON
gt; gt; SMITH T 87% LEVINE 1
gt; gt; SMITH T 76% HOGAN
gt; gt; SMITH T 102% CHRISTOS
gt; gt; LEVINE 60% CHILDS
gt; gt; SMITH T 100% CATALDY
gt; gt; ANDERSON 77% BAKERS
gt; gt;

Thanks so much for all your help !!

quot;bpeltzerquot; wrote:

gt; =sumproduct(--(A$1:A$1000=C2),--(B$1:B$1000lt;0.9))
gt; Enter that in D2 to get the count for SMITH T, then copy down as many rows
gt; as you need. Also, change the row range to cover your entire dataset
gt; (sumproduct can't take entire columns as input, though you could use
gt; $A$1:$A$65536 if necessary).
gt;
gt; quot;Juana Cafequot; wrote:
gt;
gt; gt; The formula in Column D should lookup the name in Column C, go to Column A
gt; gt; and find the corresponding name(s), then count the number of percents
gt; gt; opposite the corresponding name in Column B that are less than 90%. (I did a
gt; gt; manual count in Column D as illustration of what the final result should look
gt; gt; like.) Thanks !!!
gt; gt;
gt; gt; Column A Column B Column C Column D (Formula
gt; gt; column)
gt; gt; NamePercent earningsCriteria Count
gt; gt; SMITH K 106% SMITH T 2
gt; gt; SMITH T 101% SMITH K
gt; gt; CHILDERS 97% ANDERSON 1
gt; gt; SMITH T 92% NEWTON
gt; gt; SMITH T 87% LEVINE 1
gt; gt; SMITH T 76% HOGAN
gt; gt; SMITH T 102% CHRISTOS
gt; gt; LEVINE 60% CHILDS
gt; gt; SMITH T 100% CATALDY
gt; gt; ANDERSON 77% BAKERS
gt; gt;