Sum based on multiple conditions
i am trying to sum a column based on multiple criteria. Example
If "Capital Proposal C&D Cost" column is blank, I want to set "Total Project Cost" Column = "Final Roadmap Value" column + "Estimated C&D Cost" column
Else, I want to set "Total Project Cost" Column = "Final Roadmap Value" column + "Capital Proposal C&D Cost" column
Any advise on how to do this is much appreciated!!
Best Answer
-
Give this a try.
=IF([Capital Proposal C&D Cost]@row = "", [Final Roadmap Value]@row + [Estimated C&D Cost]@row, [Final Roadmap Value]@row + [Capital Proposal C&D Cost]@row)
Cheers,
John
Answers
-
Give this a try.
=IF([Capital Proposal C&D Cost]@row = "", [Final Roadmap Value]@row + [Estimated C&D Cost]@row, [Final Roadmap Value]@row + [Capital Proposal C&D Cost]@row)
Cheers,
John
-
@John Shane thank you so much!! That worked!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!