Sum formula
Options
holli.nunn
✭✭✭
The above formula is 'unpars' ... What am I doing wrong? I want to total 4 columns
Tags:
Best Answer

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

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)

Thanks @KPH

Happy to help @holli.nunn !
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!