Ben Miura Posted September 12 Share Posted September 12 (edited) Hi all, I need to create a worksheet for local government compliance. In the past I have been doing this manually and I'm over it. In the worksheet I need to show the total number of plants and of that how many are natives and how many are exotics with percentages in the next column. I have been labelling native / exotic in the Comment 1 field of the Plant Style. I also need a total of how many species and the percentage that are native vs exotic. I have tried to work the problem with no solution.... maybe it can't be done. See attached as how I think the layout should look like. Edited September 12 by Ben Miura Quote Link to comment
Vectorworks, Inc Employee JuanCarlos Posted September 12 Vectorworks, Inc Employee Share Posted September 12 For the Qty you will use =COUNT(Criteria) and for Percentage well that would be some percentage math from the results in column B https://app-help.vectorworks.net/2025/eng/VW2025_Guide/Worksheets/Entering_formulas_in_worksheet_cells.htm?rhsearch=worksheets&rhhlterm=worksheet HTH 1 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.