How to sum across multiple columns

Options

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:

Best Answer

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    Hey @Matthew Cooney

    Try this

    =SUM(Flights@row:Travel@row)

    cheers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    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.

  • Matthew Cooney
    Options

    Thank you! Worked perfectly

  • mmolony
    mmolony ✭✭
    Options

    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.
    Genevieve P. Employee Admin
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!