Sum formula

Options

The above formula is 'unpars' ... What am I doing wrong? I want to total 4 columns

Tags:

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    edited 11/03/23 Answer ✓
    Options


    I see what you are doing. The [] on the help page for sum means the text within them is optional, not that you need to include them in your formula.

    You need

    =SUM(MAM2,MW2,MS2,NE2)


    Extra

    You could also use @row instead of 2 to mean the current row.

    =SUM(MAM@row,MN@row,MS@row,NE@row)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!