Adding in a cell via if then?
Hello Community, I need help with a formula. I would like to add the totals into one cell based on the following condition but don't know how to write the formula.
For example, if the Status column, has any of the following results, then add the amount in the "Amount" column in this cell.
Any help would be appreciated.
Best Answers

You would need something like this:
=SUMIFS(P&I Amount]:[P&I Amount], Status:Status, OR(@cell = "Confirmed", @cell = "Committed", @cell = ...........))

Thanks @Paul Newcome. That worked!
Answers

=IF(OR([Status Column Name]@row = "Value 1", [Status Column Name]@row = "Value 2", [Status Column Name]@row = "Value 3"), [Amount Column]@row, 0)

Hello @Sameer Karkhanis , thank you for your help. I don't think I was being clear.
I am hoping to sum up the amount in the P&I Amount Colum if the Status Colum is Conformed or Needs Org Profile Updates, or Summited (under review), or etc. in the Total Approved cell row 43 and column P&I Amount.
I think it is a sumif formula. The formula I currently have is =SUMIF(Status1:Status42, "Confirmed", [P&I Amount]1:[P&I Amount]42 but I would like it to search the whole Status Column and the whole P&I Amount column.

You would need something like this:
=SUMIFS(P&I Amount]:[P&I Amount], Status:Status, OR(@cell = "Confirmed", @cell = "Committed", @cell = ...........))

Thanks @Paul Newcome. That worked!

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!