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

Gavin Seaton

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

Paul Newcome

Try this instead:

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

Aaron Jenness

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!

Paul Newcome

Try this instead:

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

Aaron Jenness

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!

Gavin Seaton

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

Paul Newcome

Happy to help. 👍️