Function To Fill In Table

Occasional Contributor

Can someone please help me with a formula that would take the table on the left in the exam shown, and use this data to create the table on the right?



3 Replies



Here is a suggested solution with pivot.


I would be happy to know if I could help.



I know I don't know anything (Socrates)


* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

best response confirmed by KC371 (Occasional Contributor)



You could also use a =SUMIFS. Use this formula in your table on the right, it sums QTY if the line matches the corresponding color and size. 


In F3 put:


You can then copy this to all empty cells in your calculation table. You can add sizes and colors with this too if needed.




Thank you very much @DKoontz. Very simply formula and all that I was looking for. Really appreciate the help!