Unable to sum 6 cells from different sheets

I am quite new to Smartsheet and I am trying to sum the totals from 6 different sheets onto one master file sheet and I am getting the #UNPARSEABLE ERROR. I just typed =SUM( then I clicked reference another sheet and then clicked on the correct cell reference in that sheet and then I repeated until I had all 6 cell refences then I pushed enter. What am I doing wrong?

This is what my formula looks like;

=SUM({Rajeana H Range 4}{Carissa W Range 1}{L'Tisha S Range 1}{Cindy W Range 1}{Chris B Range 3}{Steve K Range 1})

Also, I refenced a single cell, not a range. So not sure why it is showing a range as the reference?

Find more posts tagged with

Accepted answers

All comments

John Jonassen

Hi @Valerie Baxter ,

Try placing commas in between each reference.

=SUM({Rajeana H Range 4},{Carissa W Range 1},{L'Tisha S Range 1},{Cindy W Range 1},{Chris B Range 3},{Steve K Range 1})

Valerie Baxter

=SUM({Rajeana H Range 2}, {Carissa W Range 2}, {L'Tisha S Range 2}, {Cindy W Range 2}, {Chris B Range 1}, {Steve K Range 2})

Ok entered comas, getting closer thanks. My value is now off by 20, which is the value for the last two cell references. Not sure why one of them is not adding properly.

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.