Modify SumIF... Array Formula

[Guest]

I am using this formula.

=SUM(IF((TMS2!$BL$3:$BL$60000<=WatchList!$A$4)*(TMS2!$K$3:$K$60000="050S0F1");TMS2!$F$3:$F$60000))

Is it possible to modify this part (TMS2!$K$3:$K$60000="050S0F1") to set the
criteria to look for all cases where the cell equals 050S0F1, 050S0F2 ...
050S0FB. In other words, any cell where the left 6 characters are 050S0F ?

Thank you in advance.

 

[Guest]

Replace ; with a comma in LEFT() ?

Alok Joshi

It is better to use sumproduct and enter the formula normally

=SUMPRODUCT(--(TMS2!$BL$3:$BL$60000<=WatchList!$A$4);--(LEFT(TMS2!$K$3:$K$60000;6)="050S0F");TMS2!$F$3:$F$60000)


Regards,

Peo Sjoblom

 

[Guest]

No, look at the OP's original post, he's obvisoulsy using Eurpoean delimiters

Regards,

Peo Sjoblom