How to sum across multiple columns

Matthew Cooney

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

thumbnail_image005.png

Kelly Moore

Hey @Matthew Cooney

Try this

=SUM(Flights@row:Travel@row)

cheers

Kelly Moore

Hey @Matthew Cooney

Try this

=SUM(Flights@row:Travel@row)

cheers

Mark Cronk

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

Matthew Cooney

Thank you! Worked perfectly

mmolony

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.

Genevieve P.

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