Jim Smith Posted May 4, 2018 Share Posted May 4, 2018 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. Quote Link to comment
poco2017 Posted May 5, 2018 Share Posted May 5, 2018 You may want to try: Area ((L= 'Main') & ( C IN [ 'xxx', 'yyy', 'zzz'] ) ) Quote Link to comment
Miguel Barrera Posted May 5, 2018 Share Posted May 5, 2018 if your first worksheets has the total, you can reference that cell into the second worksheet that only contains totals. 1 Quote Link to comment
Jim Smith Posted May 6, 2018 Author Share Posted May 6, 2018 Awsome ! Thanks very much! Quote Link to comment
Recommended Posts
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.