Hello All,
I am trying to sum amounts for various accounts by department and the lookup values are in a single cell. Please see the attached spreadsheet. Example 1 has the solution that I am looking for and I found it on this forum. However, I am trying to lookup account numbers (See Example 2) that are stored as text and the solution in my example 1 does not work with the account numbers.
Bookmarks