markdd Posted October 7, 2018 Share Posted October 7, 2018 I am trying to place a Total amount for a worksheet column and have drawn a complete blank. Is there a formula I need to enter into a cell that will return the total number reported in a column? Quote Link to comment
Vectorworks, Inc Employee Tamsin Slatter Posted October 7, 2018 Vectorworks, Inc Employee Share Posted October 7, 2018 Hi Mark Just put =A2 in the total cell (for your example). That will always return the sum of the values in that column. Quote Link to comment
Vectorworks, Inc Employee Tamsin Slatter Posted October 7, 2018 Vectorworks, Inc Employee Share Posted October 7, 2018 You may need to stop the cell from grouping the results though. So, click on the arrow beside A2 and change how it reports the results so that you don't get any summary on the rows below. 1 Quote Link to comment
markdd Posted October 7, 2018 Author Share Posted October 7, 2018 (edited) I tried those and sadly none of those work! I have a feeling it has something to do with the data that is being reported. I'm attaching the file!! What I should have said is that it is reporting data from a lighting instrument which I would like to get a total quantities for. Worksheet totals.vwx Edited October 7, 2018 by markdd Quote Link to comment
Pat Stanford Posted October 7, 2018 Share Posted October 7, 2018 'Lighting Device'.'Clamps' is formatted as a text field instead of a number field. Either change the field type to a number format or use a formula in column A of =Value('Lighting Device'.'Clamps') so you have numbers that can be summed. 4 Quote Link to comment
markdd Posted October 7, 2018 Author Share Posted October 7, 2018 This is great Pat. Learned two things today! Mark 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.