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.

You may want to try:

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

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

Awsome ! Thanks very much!

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.

×   Pasted as rich text.   Restore formatting

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×