I did use the following formula in column Steem/SBC
=if(right(C2;3)="eem";"Steem";"SBD")
If you run this you will have to copy the result column and past it again as values. We will remove the Steem and SBD from the amount column to be able to add it up!

Thanks for sharing as I was assuming there was a way to do this, but hadn't taken the time to look it up. I have been wanting to use some of that information on steem detective and will have to go back and revisit it now!