80-20 Sheet trial.xlsx | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
15 | HUIZI003 | 48140938 | 03 | NWO | Q19944 | BRUSH,CIRC | 20210108 | 20210108 | -138.96 | 18 | CASE07 | -272.16 | |||
16 | HUIZI003 | 48140938 | 03 | NWO | Q19944 | BRUSH,CIRC | 20210108 | 20210108 | 138.96 | 18 | CASE07 | 216 | |||
17 | BELLE003 | AE3067 | 07 | GAR | P68836 | HARNESS | 20210111 | 20210111 | 464.1 | 696.15 | AGEX01 | 696.15 | |||
18 | MURRO001 | 541601 | 07 | GAR | P68837 | BANDIT CIH R | 20210111 | 20210111 | 832 | 130 | YIEL01 | 1248 | |||
19 | MURRO001 | 541600 | 07 | GAR | P68837 | BANDIT CIH L | 20210111 | 20210111 | 832 | 130 | YIEL01 | 1248 | |||
20 | MAGOS001 | 84475542 | 07 | GAR | P68870 | FILTER, ENGINE | 20210112 | 20210112 | 26.54 | 18.5 | CASE07 | 37 | |||
21 | MAGOS001 | 86982522 | 07 | GAR | P68870 | FILTER, AIR | 20210112 | 20210112 | 57.96 | 54.25 | CASE07 | 108.5 | |||
22 | MAGOS001 | 86982523 | 07 | GAR | P68870 | FILTER, AI | 20210112 | 20210112 | 35.24 | 25.25 | CASE07 | 50.5 | |||
Sheet1 |
Good afternoon, The above sheet is an excerpt of data that i pull monthly. I'd like to see if I can start to glean out dollars throughout the course of the year by customer. The information I need is is column A (customer) and Column M (Sell price). Is there a way to do monthly data dumps into one sheet, have excel look for the customer name, if it already exists or not put it into another column and total everything for the year in the new columns. The above example should tally
HUIZI003 -56.16
BELLE003 696.15
MURRO001 2496
MAGOS001 196
Next month these customers might buy something again, and I would like it to tally them and add to existing. as well as add new customers if needed. THis might be a big ask, but its definitely over my head. Please aske me a question if my explanation isn't good.
Thanks,
Seth