# Sum based on multiple conditions

Options

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!!

• ✭✭✭✭
Options

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

• ✭✭✭✭
Options

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

• Options

@John Shane thank you so much!! That worked!!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!