Adding Values Based on a Separate Column
 

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

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

"=SUMIF((Range,Criteria,SumRange)"
as in SUMIF(D:D,"CE",B:B) gives the total for CE (=13)
If CE is in cell Sheet2!A1, with the data in Sheet1 use
=SUMIF(Sheet1!D:D,A1,Sheet1!B:B) in Sheet2!B1, then you
can copy the formula down for the other locations

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