J
Jones
I need help with a function I don't quite understand.
I have a column of numbers that are coded by initials in the next column.
Example:
Column A has 30 entries from A3 to A33. Column B has corresponding initials
next to each number from B3 to B33. There are 6 different sets of
inititials, each corresponding to different number entry in column A.
I would like to add the total values for each set of initials without
sorting column B. Ideally I'd like to keep a running total for each set of
initials.
How do I do this?
Thank you in advance for any solution to this seemingly easy problem.
Bill Jones
I have a column of numbers that are coded by initials in the next column.
Example:
Column A has 30 entries from A3 to A33. Column B has corresponding initials
next to each number from B3 to B33. There are 6 different sets of
inititials, each corresponding to different number entry in column A.
I would like to add the total values for each set of initials without
sorting column B. Ideally I'd like to keep a running total for each set of
initials.
How do I do this?
Thank you in advance for any solution to this seemingly easy problem.
Bill Jones