# quantity of doors in schedule

## Recommended Posts

Is there any way to make a column listing the quantity of doors in the door schedule?

##### Link to comment

More details on what you want please. Are you looking for just a count of the total number of doors? Or are you looking to have doors of the same "type" summarized in the schedule with a count for the number of each type?

##### Link to comment
26 minutes ago, Pat Stanford said:

More details on what you want please. Are you looking for just a count of the total number of doors? Or are you looking to have doors of the same "type" summarized in the schedule with a count for the number of each type?

As shown in the image below, theres 8 of the same doors and I would a column that lists the sum of the same door. The red # which represents the quantity in the image is what I'm trying to achieve.

##### Link to comment

You need the function "=count" in your header row.

##### Link to comment

In your database header for each column, there is a little disclosure triangle (downward pointing triangle).Click it and you will get the following dialog box.

If you click the Summarize Items check box, it will compress all of the items with the same value into a single row. If you click the Sum Values button, it will then add up all of the values for each of the compressed items.

As @Markvl says, add a column with a formula of =count, figure our what column you want to summarize on and you should be set to go.

Ask again if you need more help.

##### Link to comment

Hello,

Here is it. I actually added a column with style (the formula is =PST) and another with count (formula is =count). I then use the sum button on the style column to summarize the item.

##### Link to comment

However, I find it annoying that the worksheet also sums the width, height and Thickness... So I thought that to solve this I could use the formula =(Door.Width)/C4 instead then just =(Door.Width)... alas it does not work.  The worksheet just ignore the /C4, it does not return an error though, the result is simple unchanged. Would someone have an idea why?

##### Link to comment

Check the settings for those columns. If the Sum Values check box is checked, uncheck it. The values should not be summed unless that box is checked.

##### Link to comment

Hi Pat,

thank you ! I can see that check box in 2018 (when I convert the file) and it really does the trick. However this worksheet is in 2017 is there an equivalent to the Sum Values check box in 2017?

##### Link to comment

Hello,

I got the answer from techsupport. The equivalent in 2017 is to drag the sum sign into the column you want to "uncheck". Here summing the G and H column actually allow not to sum the width and height of each item...

##### Link to comment
• 3 years later...
On 9/8/2020 at 11:19 AM, Mark Aceto said:

I'm dying to know if the 3D Grid Line tool is actually a 3D object or if it's only viewable in ortho planes that look like when I import a PDF/DWG provided by the venue (as presented in the marketing materials).

@Pat Stanford How can yo view the doors/windows in elevation on the schedules? Completely forgot. Thanks

##### Link to comment

Formula is "=image"

##### Link to comment
5 minutes ago, Boh said:

Formula is "=image"

Yes, but I get a plan view.

##### Link to comment

Go to the 'Images' tab of the 'Format Cells' dialog box + there you can set the type, size + view of the image

## 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 previous content has been restored.   Clear editor

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

×
×

• KBASE
• #### MARIONETTE

×
• Create New...