# How to use a column to add up all columns in a row **URL:** \ **Category:** Ask for Help\ **Created:** [December 31, 2024, 3:18am UTC](https://community.glideapps.com/t/how-to-use-a-column-to-add-up-all-columns-in-a-row/78866 "2024-12-31T03:18:47Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![TomNCSCorp](https://avatars.discourse-cdn.com/v4/letter/t/b5e925/32.png) [@TomNCSCorp](https://community.glideapps.com/u/TomNCSCorp)\ **Post date:** [December 31, 2024, 3:18am UTC](https://community.glideapps.com/t/how-to-use-a-column-to-add-up-all-columns-in-a-row/78866/1 "2024-12-31T03:18:47Z")
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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 31, 2024, 3:23am UTC](https://community.glideapps.com/t/how-to-use-a-column-to-add-up-all-columns-in-a-row/78866/2 "2024-12-31T03:23:00Z")
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. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 31, 2024, 3:26am UTC](https://community.glideapps.com/t/how-to-use-a-column-to-add-up-all-columns-in-a-row/78866/3 "2024-12-31T03:26:24Z")
Another alternative is to use a math column to add all columns together.