I would use a Pivot Table. To learn more about them, see:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
HTH
Jason
Atlanta, GA
-----Original Message-----
I have a spreadsheet where the number of Items delivered
is listed in Column
B and the location of where it was delivered in Column D.
What I need to do is in a different Tab sum the values
in Column B, but
grouped by Column D.
i.e
ColumnB ColumnD
5 CE
6 CW
8 R1
8 CE
And on the other tab I need to separately total each in
Column D:
CE 13
CW 6
R1 8
Thank you!!!
.