Sum 2 Cells in different columns only when a 3rd Cell in another column is blank
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
-
Try this instead:
=IF([Agreed Final Account]@row = "", [PO Value]@row + [Approved CR's (£)]@row)
-
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
-
Try this instead:
=IF([Agreed Final Account]@row = "", [PO Value]@row + [Approved CR's (£)]@row)
-
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!
-
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
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!