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?

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!