SUMIF based on Right 3 Characters
 

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.

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


--
Don Guillett
SalesAid Software

"carl" wrote in message
...
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.

Try

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


Regards,

Peo Sjoblom

"carl" wrote:

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.