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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!