SUMIF with cross sheet referencing

Veronica GM
edited 12/09/19 in Smartsheet Basics

Hello all,

I created a sumif formula that would reference another sheet. 

Copied below is my formula but it always results as "incorrect argument". I believe the problem is in the sum range (bolded in formula). Can someone please assist? 

Thank you,

=SUMIF({SIS Quarter 1 Range 1}, [Column15]48, {SIS Quarter 1 Range 2})

Comments