Hi,
I'm trying to use a SUMIF function where I have two strings that are equal in the same cell. Example data:
MI/IL | 10
NY/NY | 3
NY/MI | 7
IL/IL | 6
Ideal Output:
Same State | 9
There is another place in my data where I concatenate this data together, if that's any help to solving this. Any help would be much appreciated. Thanks
Bookmarks