I have a table with three columns: Corporate, Engineering and Manufacturing. Is it possible to add a column for Total that will sum the values in each row from the three previous columns?
How to add formula to table to sum columns
Userlevel 2
+3
Hi
If you are trying to SUM values in individual cells of a table in Lucidchart, you can achieve this by adding some custom data to the table to represent the value in each cell.
You can reference individuals cells in a table using A1, A2, A3, B1, B2, B3 etc. In the custom shape data for your table, you can create a property field for each cell you want to include in the SUM. As the value for that field, I added a formula to reference the number on that particular cell: =this!A2 for cell A2, =this!B2 for cell B2 and so on.
Then I added this formula to the cell I wanted to display the count in: =SUM(@"A2",@"B2",@"C2").
I hope this helps! If this doesn’t address what you are looking to achieve or you have any questions, feel free to comment below.
Reply
Create an account in the community
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to create an account.
Log in to the community
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to log in.
Login with SSO
Log in with Lucidor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.