ermccarthy
Board Regular
- Joined
- Feb 15, 2002
- Messages
- 224
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!!!!
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!!!!