Forum Discussion
Solved
Function To Fill In Table
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?
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:
=+SUMIFS($C:$C,$A:$A,$E3,$B:$B,F$2)
You can then copy this to all empty cells in your calculation table. You can add sizes and colors with this too if needed.
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:
=+SUMIFS($C:$C,$A:$A,$E3,$B:$B,F$2)
You can then copy this to all empty cells in your calculation table. You can add sizes and colors with this too if needed.
