dsum or not?

  • Thread starter Thread starter Jones
  • Start date Start date
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
 
Hi

=SUMIF(B$3:B$33,"JS",A$3:A$33)
etc. for every set. You also can use cell reference for inicials.
 
Back
Top