I have a list of about 100 names in column A, and a value in column B. I am currently using a sumif function to add all the numbers matching one of the names. How do I add the ones that do not match? Such as if I do not have the name Brock in my list, it's value will not get added, but I want it added to a row at the end of my names list, listed as Other, that gathers it and any other non used name's value.