Adding Values Based on a Separate Column

B

binder

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

Guest

"=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
 
Top