EXCEL How do I summarize a list? -

i going best explain have , need.

i have list of wood pieces (length x width) want summaries in order have pieces quantity of every type of piece.

for example

this list has 3 columns (colum colum b , colum c)

colum shows length

colum b shows width

colum c shows quantity

and in list, same type of piece can shown few times , whit different quantities.

looks this

10x10 1

10x10 4

20x40 6

30x40 1

30x40 5

20x40 3

i’m looking solution can me to:

sum quantity shown in colum c same type of wood piece.

the solution example next.

10x10 5

20x40 9

30x40 6

clik example image example

try sumifs formula (see image). first you'll need manually enter different combinations of length , width (see columns e , f).

solution