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
Help Article Resources
Categories
Check out the Formula Handbook template!