# Sum 2 Cells in different columns only when a 3rd Cell in another column is blank

Options
✭✭✭✭

Hi

Im trying to get a formula to add 2 cells together, but only when a 3rd cell is blank.

The formula i have doesn't give an error but it doesn't give an answer either!

The sheet and formula are shown here. In the column 'Forecast Final Account if not agreed' Add 'PO Value' and Approved CR's (£)' when 'Agreed Final Account' is blank:

=IF(ISBLANK([Agreed Final Account]@row), "", SUMIF([Agreed Final Account]@row, [PO Value]@row, [Approved CR's (£)]@row))

In the future id like to link the 'Approved CRs (£)' column to another sheet to pull that figure through and dont know if having this column as a formula would affect how a formula would work in the 'Forecast Final Account if not agreed' Column.

Gavin

• ✭✭✭✭✭✭
Options

=IF([Agreed Final Account]@row = "", [PO Value]@row + [Approved CR's (£)]@row)

Options

Looks like Paul beat me to it

**********************************

Hi Gavin,

The following worked for me:

=IF(ISBLANK([Agreed Final Amount]@row), SUM([PO Value]@row + [Approved CR's (£)]@row), " ")

This only adds the "PO Value" and "Approved CR's" values if the "Agreed Final Amount" is blank. If the "Agreed Final Amount" cell is not blank then "Forecast Final Account if not agreed" cell is blank.

Hope that's what you're looking for, cheers!

• ✭✭✭✭✭✭
Options

=IF([Agreed Final Account]@row = "", [PO Value]@row + [Approved CR's (£)]@row)

Options

Looks like Paul beat me to it

**********************************

Hi Gavin,

The following worked for me:

=IF(ISBLANK([Agreed Final Amount]@row), SUM([PO Value]@row + [Approved CR's (£)]@row), " ")

This only adds the "PO Value" and "Approved CR's" values if the "Agreed Final Amount" is blank. If the "Agreed Final Amount" cell is not blank then "Forecast Final Account if not agreed" cell is blank.

Hope that's what you're looking for, cheers!

• ✭✭✭✭
Options

Hi @Paul Newcome thank you, that worked. Appreciate you posting the formula.

@Aaron Jenness Thanks also for coming back to me - that works too

Kind Regards

Gavin

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!