I am trying to sum column B based on part of the text in column A. Column A contains account numbers in the following format "5-25-75-244", "5-25-76-304", "5-26-74-999", 5-26-75-400", and column B contains the corresponding values.
How do I sum only account numbers starting with "5-25"?
Bookmarks