potato.king
New Member
- Joined
- Dec 19, 2011
- Messages
- 3
I need to do a sumif based on the first 3 numbers for both the range and the criteria. The 1st 3 numbers in the range column (Column A), the 1st 3 numbers in B1. The easiest way would be to create a whole new column and run a =Left(A1,3) and copy that down and make that my new "range" column. I hate adding columns for functions. Any help would be greatly appreciated. Thanks again in advance! Here is what I'm trying to do:
sumif(Left(A1:A100,3),Left(B1,3),C1:C100)
sumif(Left(A1:A100,3),Left(B1,3),C1:C100)