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?
Question
How to add formula to table to sum columns
+5Hi
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.
Create an account in the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in to the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in with Lucid
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
