Component Area by Class

[martinfdc]

Hi,

 

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,

 

Martín

 

[Pat Stanford]

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

[martinfdc]

Many many thanks @Pat Stanford it works great.