SUMIF with cross sheet referencing

Veronica GM

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})

Dan Seidler

Try , =[Column15]48.  The criterion is a condition that the SUMIF formula is looking for.  In this case "equals this cell".

Here's a good reference:  https://help.smartsheet.com/function/sumif

Paul Newcome

I believe it is actually a problem with your criteria (bold portion below).

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

You would need to specify whether it equals, is less than or greater than, etc.

If that doesn't help, maybe post some screenshots so we can see what exactly you're working with.

Veronica GM

Thank you! This helped!

Veronica GM

Thank you very much!

Seth Morth

Almost 4 years later this thread (and the other cross sheet reference threads) helped me. Thanks all!