Help with Array Function

[Gos-C]

Hi Aladin,

It appears to be counting all appearances of each name. If there ar
two names, only the second name should be counted.

Thank for such quick response

 

[Aladin Akyurek]

=SUMPRODUCT(($A$1:$A$5=D1)+ISNUMBER(SEARCH(D1,REPLACE($A$1:$A$5&"/",1,SEARCH("/",$A$1:$A$5&"/"),""))),--($B$1:$B$5="Red"),--($C$1:$C$5>"31-Dec-03"+0),--($C$1:$C$5<"1-Sep-04"+0))

 

[Aladin Akyurek]

You can actually omit the &"/" bits...

=SUMPRODUCT(($A$1:$A$5=D1)+ISNUMBER(SEARCH(D1,REPLACE($A$1:$A$5,1,SEARCH("/",$A$1:$A$5),""))),--($B$1:$B$5="Red"),--($C$1:$C$5>"31-Dec-03"+0),--($C$1:$C$5<"1-Sep-04"+0))