Unable to sum 6 cells from different sheets

Valerie Baxter

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?

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.