Hello and thanks for your time.
I am attempting to create a SUMIF function that sums a set of values based on a specific spot in a text string.
Each value has a corresponding Item # made up of the following features:
Year Month Day State Program Code Location
15 01 01...