Seemingly simple sum question

jbogerhawkins

Hello, I have a very basic sheet where I am trying to sum the results of 3 separate columns (MST1, MST2, and MST3). I am using the formula

=SUM([MST1]@row:[MST3]@row)

Which doesn't create an error message, but yields only 0's despite the fact that there are numbers in the other columns. Any thoughts on why this formula is not working?

Paul Newcome

How are the numbers in the other columns being populated?