SUMIF with cross sheet referencing

Options
Veronica GM
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