0

How can I generate the Total column from the below screenshot?

As you can probably see, it's a total of all of the Quantity values for a given Order number. From which I can derive Proportion, and that part's nice and simple once Total is filled.

I think there's probably a simple solution but I can't my head around it.

Order/Quantity/Total/Proportion

3

Please try:

=sumif(A:A,A2,B:B)  

in C2 and copy down to suit.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.