Thanks andro55 for your reply but putting the auto sum only gives me the total length of all the beams . what i'm after is a summarised total of the quantity of the same length/type beams with it's individual length in the same row
this is so i could order timber straight from the one schedule example
15 joists @ 5,000m
rather than 75,000m of joist