count values from one column based on condition, with array

Hi,

I have several values in Column "I" and in Column "H" 2 values = "Check", "OK". Now I can Count the number of "Targets" for each Target manually, but cannot code with an Array which could do it automatically.check.PNG
I wanted to have 2-D Array, which would Show me following for "Check". Is there any "quick" way to do it with Array? (of course I could do it with Pivot, but just wanted with Array). Could you help further?

Target_1 Count 3
Target_4 Count 1

HTML Code: 

As mentioned you could use COUNTIFS

Something like:

Please Login or Register  to view this content.

If you will have more unique target values then you could first loop the target range and create an array or collection of the uniques instead of my const/split method. This gave me the counts 3,0,0,1,0. If you need to actually place the counts somewhere you would need to assign the result of the function to a variable or range objects value.

thank you, I thought of collections or dictionaries, but I am not so far...will try with your method