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

  • 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
    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.

    thinkspi.com

  • Thank you! This helped!

  • Thank you very much!

  • Seth Morth
    Seth Morth ✭✭✭✭✭✭

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