DataSubtotals

Make sure you have a Title for each column.........Name........Amount

At each change in name.....sum.......add subtotal to........amount

Click on the 2 from the 123 to see only each person's subtotal.


Gord

On Mon, 21 May 2012 19:39:22 +0000, AuditorLisa
wrote:


I have a list of names and payments for each person. Most people are
listed more than once. I am trying to auto sum each person so there's
only one value person.

Any suggestions as to how to do this?

example:
Kendra $750.00
Kendra $375.00
Tyeisha $495.00
Tyeisha $247.50
Daniel $750.00
Daniel $750.00
Daniel $750.00
Joshua $750.00
Yolanda $750.00
Yolanda $750.00
Akiesha $750.00
Jessica $750.00
Jessica $750.00
Rodarial $750.00
Rodarial $750.00