Jump to content
Jim Smith

Worksheet Area Totals

Recommended Posts

Generally we calculate areas by classes that are essentially Sub classes. While clients need to see these sub class information, Building officials are only interested in the overall uses. For example the city only needs to see Residential, Office, and Mercantile areas but the client needs to know more sub headings for each area. What we now show on a spread sheet is each Class & a the spread sheet then totals these cells.


Here's my question: I would like to have a second spreadsheet that just has the totals. Is there a way to write a formula that would allow me to  say total all the Mercantile areas rather than having five or six Cells of areas then a Total? 


I've tried =AREA(((L='Main') & (C='xxx'))+((L='Main') & (C='yyy'))+((L='Main') & (C='zzz')))

But that don't work. Any thoughts I'm thinking I might just use the same spreadsheet but just shrink the cells I don't want to see.

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.

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.


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