Trying to use SUMIF to add columns a crossed a row

Ascottnewcombe

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?

Paul Newcome

Yes. Try this:

=IF([Committed or Projected]@row = "Projected", SUM([Jan-23]@row:Dec-23]@row))

Paul Newcome

Are you able to provide a screenshot for reference? It almost seems like you are wanting a different formula (IF with a SUM as the output), but I can't be sure without seeing your structure.

Ascottnewcombe

Hi Paul thanks for the quick response I was in meetings all afternoon. I hope the above helps The plan is to create a Formula for the Annual Committed Spend for 2023 and one for Projected that only does the sum if the value in Committed or projected is selected.

Thanks

Scott

Paul Newcome

Yes. Try this:

=IF([Committed or Projected]@row = "Projected", SUM([Jan-23]@row:Dec-23]@row))

Ascottnewcombe

Thank you I was able to make this work.

Paul Newcome

Happy to help. 👍️