(Solved) – Sum quantity based on 3 unique cells?

(solved)-–-sum-quantity-based-on-3-unique-cells?

I’ve got a large amount of data and I need to consolidate unique rows based on 3 columns and then sum the value in a fourth. the problem is excel can only look at one column at a time to consolidate duplicates. the source data looks similar to this.

a|b|c|10
a|b|c|20
z|x|c|15
z|x|c|10

and I need it to look like this

a|b|c|30
z|x|c|25

Any ideas?

Leave a Reply

Your email address will not be published. Required fields are marked *