Jump to content
Sign in to follow this  
Pyrotechnic

Sorting and subtotaling worksheets

Recommended Posts

I am trying to sort and subtotal my worksheet. I have a record setup that gives me types of signs and I would like the worksheet to give me a total of each sign type. If anyone knows how I can accomplish this please let me know.

Share this post


Link to post

I checked out the discussion you posted, but the example in there is in VW 2008. I am still in the previous version so I couldn't check it out. I know how to summarize the worksheet to show what types I have I just can't figure out how to make the worksheet give me a count of how many of each type that I have. If there is a way for me to open your example that would be a great help.

Share this post


Link to post

Add a column in the database worksheet. In the database row for that column tpy the formula "=COUNT" (no quotes). That should get you what you are looking for.

Edited by Jeffrey W Ouellette

Share this post


Link to post

Although, is there are like a SUMIF function in VectorWorks?

To tackle the issue of subtotaling? Meaning, say I have 3 different uses of areas which are stored under one record field and I want the subtotal for 3 types of AREA on either between database cells or on a separate spreadsheet cell, what should I do?

Share this post


Link to post

There is no SumIf function, but you can use the Count outside of the database rows and give it a criteria that will only give you the objects you are looking for something like:

=count('MyRecord'.'MyField'='Type1');

The other option is to split it up and create three different database section one for each type and then do the counts from there.

Share this post


Link to post

Yes now I got it to work, thanks Pat, I did;

=AREA('MyRecord'.'MyField'='Type1')

fyi...

Edit #1: Now I'm trying to do

=AREA('MyRecord'.'MyField'≠'Type1')

which ends up in <> signs for exchange with ≠ when you run it.

Any ideas on this one?

Edited by sle7en7

Share this post


Link to post

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.

Guest
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.

Sign in to follow this  

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×
×
  • Create New...