Pyrotechnic Posted May 28, 2008 Share Posted May 28, 2008 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. Quote Link to comment
Jeffrey W Ouellette Posted May 28, 2008 Share Posted May 28, 2008 Chad, This previous thread talks about summarizing schedules: http://techboard.vectorworks.net/ubbthreads/ubbthreads.php?ubb=showflat&Main=21474&Number=103651#Post103651 There is even a door schedule example, but the concept is the same and can be applied to any object. Quote Link to comment
Pyrotechnic Posted May 30, 2008 Author Share Posted May 30, 2008 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. Quote Link to comment
Jeffrey W Ouellette Posted May 30, 2008 Share Posted May 30, 2008 (edited) 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 May 30, 2008 by Jeffrey W Ouellette Quote Link to comment
sle7en7 Posted October 6, 2014 Share Posted October 6, 2014 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? Quote Link to comment
Pat Stanford Posted October 6, 2014 Share Posted October 6, 2014 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. Quote Link to comment
sle7en7 Posted October 6, 2014 Share Posted October 6, 2014 (edited) 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 October 6, 2014 by sle7en7 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.