Sum multiple Unique Values in col
I have a spreadsheet that looks like this:
Account # of
# Orders
22000015 1
22000015 1
22000015 1
22000015 1
22000015 1
22000015 2
22000015 3
22000023 1
22000049 2
22000074 1
22000074 1
22000074 1
22000074 1
22000074 1
22000074 1
22000074 1
22000074 1
22000074 2
I want to auto sum the # of orders for each account so I get a result that
looks like
22000015 10
22000023 1
22000049 2
22000074 10
can anyone assist?
Thanks - dan
|