Jump to content

Worksheet summary


Recommended Posts

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

Link to comment
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

Link to comment

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.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...