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$6 0000)

Thank you in advance.