Jump to content

Recommended Posts



Establishing criteria for databases is easy: 


Database header cell: =CompAreaByClass('Class-1') using the previous function and establishing criteria I manage to show results only form a particular layer.


What I can't do is the following, I want in a normal worksheet cell to get the area of my components but specify from which layer.

I know I have to use this function:


 Spreadsheet cell: =CompAreaByClass(t=wall,'Class-1')


What do I need to add to the function above to specify the search in a particular layer?


Thanks in advance,




Share this post

Link to post

=CompAreaByClass(((L='Design Layer-1') & (T=WALL)), 'Class-1')


You can use the Insert Criteria function in the Insert menu of the worksheet to create just about any criteria combination that you need.

  • Like 1

Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


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.