Using Sum function on 2 referring pages

John C0

I am trying to sum to different cells on 2 different Smart Sheets and I I keep on getting a #UNPARSEABLE error. It works fine when it references only 1 sheet but I need to sum probably about 20+ sheets when I am done. Just testing with 2 right now.

Any help is appreciated

=SUM({AAA Pet Services - Sign Ups Range 1}{AAA Pet Services - Sign Ups Option 2 Range 1})

Carson Penticuff

=SUM({AAA Pet Services - Sign Ups Range 1}, {AAA Pet Services - Sign Ups Option 2 Range 1})

A comma is needed between each range to sum.

Carson Penticuff

=SUM({AAA Pet Services - Sign Ups Range 1}, {AAA Pet Services - Sign Ups Option 2 Range 1})

A comma is needed between each range to sum.

John C0

Thank you @Carson Penticuff that worked perfectly