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
-
Yes. Try this:
=IF([Committed or Projected]@row = "Projected", SUM([Jan-23]@row:Dec-23]@row))
Answers
-
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.
-
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
-
Yes. Try this:
=IF([Committed or Projected]@row = "Projected", SUM([Jan-23]@row:Dec-23]@row))
-
Thank you I was able to make this work.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!