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.

Thanks for your help

Gavin

Best Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓
    Options

    Try this instead:

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

  • Aaron Jenness
    Aaron Jenness ✭✭
    edited 11/08/22 Answer ✓
    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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!