Arrays

[GERMAN GONZALEZ]

I created the following array that reads a list of supplier names in column C and writes only unique supplier names in column O.

=IFERROR(INDEX($C$3:$C$200, MATCH(0,IF(ISBLANK($C$3:$C$200),1,COUNTIF($O$2:O3, $C$3:$C$200)), 0)),"")

What I would like to do is develop another array that looks at another column that contains yes or no values for each supplier name. Its column F and if a supplier had a Recordable Injury charged against it, a Yes value is entered into the cell or a no value. I'd like to sum all the Recordable Injury Yes values for each unique supplier name listed in column O. Any help would be greatly appreciated.

Thanks Very Much....

 

[sgroath]

I am unable to make the array function you provided do what you want. The following should work, however.

(Assuming your data starts on row 3 with headers on row 2)
In cell O3, paste:
=IFERROR(INDEX(C$3:C$200,MATCH(SUM(COUNTIF(O$2:O2,C$3:C$200)),COUNTIF(C$3:C$200,"<"&C$3:C$200),0)),"")

and make this an array function by pressing Ctrl+Shift+Enter instead of just Enter. It should show up in the formula bar as (do not type in the curly braces):
{=IFERROR(INDEX(C$3:C$200,MATCH(SUM(COUNTIF(O$2:O2,C$3:C$200)),COUNTIF(C$3:C$200,"<"&C$3:C$200),0)),"")}

Make column P your Recordable Injury Total column and in cell P3 enter (as a normal formula):
=IF(O3="","",COUNTIFS(C$3:C$200,O3,F$3:F$200,"Yes"))

Copy your O2:P3 formulas down to through roww 200 and you should have what you want.