Trying to use SUMIF to add columns a crossed a row

Below is the formula I am using

=SUMIF([Committed Or Projected]@row:[Committed Or Projected]@row, "Projected", [Jan-23]@row:[Dec-23]@row)

The error message I am getting is #incorrect Argument set.

I am basically trying to add a row range if a value is set in another column.

Can Sumif only be used on columns,s not Rows?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!