SUMIF statement failing with INCORRECT ARGUMENT SET

Eric Enterline

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,

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

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

Eric Enterline

Excellent insight. Worked.

Paul Newcome

Happy to help. 👍️