Certainly a Pivot Table is appropriate:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
Or, if the groups stay sorted, you could use Data/Subtotals...
Or you could use =SUMIF(A:A,1,B:B)
In article ,
Sandy wrote:
I have a list of people who are in certain groups, each person pays so much
money and the list is added to daily. I want to know what the totals are for
different groups.
group amt
1 50
1 25
1 75 subtot for 1
2 10
2 20 subtotal for 2
Any help