SOLVED

# Function To Fill In Table

Occasional Contributor

# 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?

3 Replies

# Betreff: Function To Fill In Table

Here is a suggested solution with pivot.

I would be happy to know if I could help.

Nikolino

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)
Solution

# Re: Function To Fill In Table

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.

# Re: Function To Fill In Table

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