Summarising a cutting list from an extensive list

  • Hi I wonder if anyone can help on this one? I have a long and varying list of kitchen cabinet components. In two of the columns there are the length and width of the item. What I want is where the sizes in both of the columns match another set of numbers somewhere else in the same columns to then add up the total (total in another column) of these pieces in another part of the spreadsheet.


    Below is a very simplified snipit of the list. I need to total up the quantities of matching sizes which I have highlighted in colours. The totals would then be in a list elsewhere. Note that the pink figures don't match so they would have to be listed with individual totals.


    It would be good if it copied the sizes to the other location and modified the quantities on that new list.


    Thankyou.


    [TABLE="width: 300"]

    [tr]


    [td]

    length

    [/td]


    [td]

    width

    [/td]


    [td]

    quantity

    [/td]


    [/tr]


    [tr]


    [td]

    720

    [/td]


    [td]

    550

    [/td]


    [td]

    2

    [/td]


    [/tr]


    [tr]


    [td]

    564

    [/td]


    [td]

    550

    [/td]


    [td]

    1

    [/td]


    [/tr]


    [tr]


    [td]

    564

    [/td]


    [td]

    128

    [/td]


    [td]

    6

    [/td]


    [/tr]


    [tr]


    [td]

    564

    [/td]


    [td]

    130

    [/td]


    [td]

    1

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    720

    [/td]


    [td]

    550

    [/td]


    [td]

    4

    [/td]


    [/tr]


    [tr]


    [td]

    564

    [/td]


    [td]

    550

    [/td]


    [td]

    2

    [/td]


    [/tr]


    [tr]


    [td]

    564

    [/td]


    [td]

    600

    [/td]


    [td]

    6

    [/td]


    [/tr]


    [tr]


    [td]

    564

    [/td]


    [td]

    130

    [/td]


    [td]

    1

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [/TABLE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!