SUMIF Different Columns
Hi, I have two columns [Initial Priced Amount] and [Final Account Amount], what I am trying to do is use the amount in [Initial Priced Amount] if the [Final Account Amount] is blank, but if it isn't blank then use the amount in it, the [Final Account Amount] column.
I want to use it in a couple of formulas in other columns in the same way, see formulas below;
=[Final Account Amount]@row  [Costs to Date]@row
=IFERROR([Difference  Cost vs Final Acc]@row / [Final Account Amount]@row, " ")
So basically what I'm trying to achieve is that if the [Final Account Amount] is blank use the [Initial Priced Amount] in the above formulas, but if it isn't blank use the [Final Account Amount].
Best Answers

Try making a separate column with the below formula and using that for all your calculations:
=IF([Final Account Amount]@row <>"",[Final Account Amount]@row , [Initial Priced Amount]@row)

Hi Leibel, I hadn't thought of a helper column that worked perfectly. Thanks.
Answers

Try making a separate column with the below formula and using that for all your calculations:
=IF([Final Account Amount]@row <>"",[Final Account Amount]@row , [Initial Priced Amount]@row)

Hi Leibel, I hadn't thought of a helper column that worked perfectly. Thanks.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!