I am using sumifs to add data on a spreadsheet. The field that I would like to compare is concatanated as follows:
01 - Red
02 - Yellow
03 - Blue
04 - Green
I would like to compare just to the numeric part of the string when reading the spreadsheet. What is the substring statement I would use to isolate the numbers. The string is indented so the numbers are not in columns 1 and 2. It appears there are possibly 2 spaces in front of the numbers.