How to use a column to add up all columns in a row

Ask for Help
1

I’m trying to convert an excel worksheet to a user friendly iPhone app,
One issue is that the excel formula that totals all the values in a row is not imported.

Example for each row there are numbers in 9 columns (all same row) the last column is a total of all the preceding columns in that row.

2

Before offering up a solution, I’ll just mention that if you find yourself needing to do this, then your data probably isn’t structured as well as it could be.

That said:

  • Use a Make Array column to create an array from all the columns you want to sum
  • Use a Rollup column and target it at the Make Array column.
2 Likes
3

Another alternative is to use a math column to add all columns together.

2 Likes