Help with SunmIf

[markoakes]

I need to adjust this formula to look at only the 3 right most digits. So it would count "123ABC" in column B. Thanks

=SUMIF(B6:B65536,"ABC",AC6:AC65536)

 

[barry houdini]

You can use "wildcards" with SUMIF, try

=SUMIF(B6:B65536,"*ABC",AC6:AC65536)

 

[GK039]

Or this one

=SUM(IF(RIGHT(B6:B65536,3)="ABC",AC6:AC65536,0))

George

 

[markoakes]

Thanks for the reply, barry houdini's answer seemed to work the best for me.