How to sum across multiple columns
Hello,
I'm looking to calculate across multiple columns and have the formula total it in the end column but I can't figure out the formula to do it, I keep coming up with #UNPARSABLE. I've attached a snapshot of the sheet
Best Answer
Answers


Hi @Matthew Cooney ,
Try placing this formula in your total column. It will work as a column formula if you want to use it that way.
=SUM(flights@row:travel@row)
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Thank you! Worked perfectly

I am having this same problem, yet I am still unable to get it to work. My equation is as follows, I also tried getting rid of the square brackets and that did not work either
=SUM([Hours Worked on program for the week]@row:Overtime@row]), yet I still get the #UNPARSEABLE error.

Hi @mmolony
Square brackets are needed around column names if there are spaces or numbers.
For example:
[Column Name]@row
However if the column name has no space, then no bracket is needed:
Column@row
Try:
=SUM([Hours Worked on program for the week]@row:Overtime@row)
Keep in mind this will SUM all values across the row between your two columns. If you only wanted to add together those two cells, another way of doing this would be to simply use +, like so:
=[Column 1]@row + [Column 2]@row
or
=[Hours Worked on program for the week]@row + Overtime@row
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 202 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!