Seemingly simple sum question

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?

Find more posts tagged with

Accepted answers

All comments

How are the numbers in the other columns being populated?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.