Worksheet Area Totals

[Jim Smith]

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.

[poco2017]

You may want to try:

 

Area ((L= 'Main') & ( C IN [ 'xxx', 'yyy', 'zzz'] ) )

[Miguel Barrera]

if your first worksheets has the total, you can reference that cell into the second worksheet that only contains totals.

 

[Jim Smith]

Awsome ! Thanks very much!