SUMIF statement failing with INCORRECT ARGUMENT SET

Hello all,

I will state up front, understanding the syntax is still challenging for me.

I have a SUMIF statement as follows:

=SUMIF({Product Helper}, "1st", {Product Estimate})

What I'm trying to achieve is to total a column in another smartsheet if the product helper from same smartsheet = 1st.

Any help appreciated,

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Start by double checking your references. They should both be referencing the same sheet and should both be the same shape and size. There are times where the sheet does not fully load in the popup window where you select your cross sheet reference. If you select a range such as a column and then the sheet finishes loading in the window, the selection will revert back to the "home cell" (top left corner of the sheet).

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!