Is it possible to write a formula where it looks at the first "2" digits of a cell, and if its equal to the criteria it would then sum? For example, in range D6:D83 i have 8 digit cost codes. The first 2 digits are the criteria I would want to use. So in the sumif formula, if the first 2 digits were "06", i would want it to sum the amount in column H (H6:H83). Is that possible ?
Bookmarks