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?


  • John Jonassen
    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})

  • =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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!