# 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

Tags:

• ✭✭✭✭✭✭

Try this

=SUM(Flights@row:Travel@row)

cheers

• ✭✭✭✭✭✭

Try this

=SUM(Flights@row:Travel@row)

cheers

• ✭✭✭✭✭✭

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.

• Employee

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