View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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!!!
.