Jun 30 2021 09:43 AM
Jun 30 2021 10:06 AM
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.
Jun 30 2021 10:18 AMSolution
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.