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