Can you do a sumif based on the first 4 characters of a column? For example:
adcd123 100
adcd290 200
adcd550 600
aklm990 300
akht880 500
adcd127 100
So sumif for adcd is 1000. I'm trying to do this without creating another column for just the first 4 characters and then sumif-ing off that column. Any ideas?
Bookmarks