jaseweil Posted December 8, 2016 Share Posted December 8, 2016 I am trying to create a framing member take off in a worksheet. I am summarizing my list by label, in other words I have all of the 2"x10" x 16' summarized together with a quantity. Can anyone tell me how to create columns in the work sheet that don't summarize along with the label? The issue I am having is that the columns for width, length, span etc... are adding up all of the widths of the members. I want the column for widths to read 1 1/2" however if I have 30 sticks of lumber it is giving me a width of 45". How do I correct this without having to list each stick of lumber independently? Thanks. sample worksheet.pdf Quote Link to comment
Guest Wes Gardner Posted December 8, 2016 Share Posted December 8, 2016 Maybe sum on that column as well ??? Quote Link to comment
jaseweil Posted December 8, 2016 Author Share Posted December 8, 2016 The sum button is always greyed out as our the ordering buttons. How do I sum (or actually un-sum) several of the columns independent of the summed label column? Quote Link to comment
jaseweil Posted December 8, 2016 Author Share Posted December 8, 2016 I figured out how to get the sum button active and I dropped it on the width column and that did the trick. Thanks Wes! 1 Quote Link to comment
RussU Posted December 8, 2016 Share Posted December 8, 2016 32 minutes ago, jaseweil said: The sum button is always greyed out as our the ordering buttons. How do I sum (or actually un-sum) several of the columns independent of the summed label column? that's an odd one and took me a little while to work that out. you need to highlight the entire row, and then the sum and order buttons become active. Hope that helps Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.