SUMIF based on Right 3 Characters

[carl]

I am using this formula. Is ther a way to modify it so that instead of
summing if the cell contains "050S0F1", it will sum if the right 3 characters
are "0F1" ?

=SUMIF(TMS1!$K$3:$K$60000,"050S0F1",TMS1!$F$3:$F$60000)

Thank you in advance.

 

[Don Guillett]

try
=SUMproduct((right(TMS1!$K$3:$K$60000,3)="0F1")*TMS1!$F$3:$F$60000)

 

[Peo Sjoblom]

Try

=SUMIF(TMS1!$K$3:$K$60000,"*0F1",TMS1!$F$3:$F$60000)


Regards,

Peo Sjoblom