Sumif if the number starts with.......

[ermccarthy]

I need a sumif formula that will calculate everything that starts with a certain 3 numbers.......

If I have a range of A1:B:200.
I want it to look for everything in Column A that starts with 110 and sum column B. I was trying something like...
=sumif(left(A1:B200,3),110,B1:B200)......I know how to write this formula if the search was for 110, but with something starting with 110, I'm Stumped!!

PS: I am not able to sort the data feild at all.

Any help would be greatly appricated!!!!

 

[Hallowedddd]

Thank you very much Mr.Akyürek from future.

Teşekkürler..