SUMIF with cross sheet referencing

edited 12/09/19

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

• 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

• ✭✭✭✭✭✭

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.

thinkspi.com

• Thank you! This helped!

• Thank you very much!

• ✭✭✭✭✭✭

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