Sum formula

holli.nunn

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

KPH

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)

KPH

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)

holli.nunn

Thanks @KPH

KPH

Happy to help @holli.nunn !