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.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You would need something like this:

=SUMIFS(P&I Amount]:[P&I Amount], Status:Status, OR(@cell = "Confirmed", @cell = "Committed", @cell = ...........))

Khanh

Thanks @Paul Newcome. That worked!

All comments

Sameer Karkhanis

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

Khanh

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.

Paul Newcome

You would need something like this:

=SUMIFS(P&I Amount]:[P&I Amount], Status:Status, OR(@cell = "Confirmed", @cell = "Committed", @cell = ...........))

Khanh

Thanks @Paul Newcome. That worked!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.