sarahrosenberg
Board Regular
- Joined
- Aug 27, 2002
- Messages
- 190
I tried to search the forum for an answer to this question, but couldn't figure out exactly what to search for.
I want to do a sumif, but instead of searching for an exact cell reference, I want to search for a "like" cell reference. For example
Illinois South 5
Illinois North 6
Missouri West 8
Ohio South 9
Illinois West 6
I want to do a sumif that would pull all of the Illinois references eventhough there are other words in the cell reference. (My real data isnt' quite as uniform, so a text-to-column won't work.)
Help please!
I want to do a sumif, but instead of searching for an exact cell reference, I want to search for a "like" cell reference. For example
Illinois South 5
Illinois North 6
Missouri West 8
Ohio South 9
Illinois West 6
I want to do a sumif that would pull all of the Illinois references eventhough there are other words in the cell reference. (My real data isnt' quite as uniform, so a text-to-column won't work.)
Help please!