Sum based on multiple conditions

Tammy_Bentz

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

John Shane

@Tammy_Bentz

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

@Tammy_Bentz

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

Tammy_Bentz

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