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.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!