Sumproduct Isnumber Search is returning same result for different values

Hi ,

Try this :

Formula:

=SUMPRODUCT(SUBTOTAL(3,OFFSET($F$11:$F$23733,ROW($F$11:$F$23733)-MIN(ROW($F$11:$F$23733)),,1)),ISNUMBER(SEARCH("X",E11:E23733))+0,ISNUMBER(SEARCH("F",$K$11:$K$23733))+0,ISNUMBER(SEARCH(" 2 "," " & $H$11:$H$23733 & " "))+0)

The changes are highlighted.

This is an array formula , to be entered using CTRL SHIFT ENTER.

Narayan