Sort the table by names, then use datasubtotal, for each change in A sum B


--

Regards,

Peo Sjoblom

"Kris" wrote in message
...
Is there a formula that will sum a column based on another column?
Example: Two columns: A has names of people B has amounts of pay for
those
people. Is there a formula that will pull a subtotal for each person in
column A