SumIfs with multiple values from same column

I'm attempting to Sum $ based on several statuses in the Status Column, but can't figure out how to use multiple values.

I successfully used the below to sum for one status, but need to add 3 more statuses "Pending Mail Merge" , "Awaiting Calculation" and "Payment Received"

=SUMIFS([Amount of Bonus Owed to Company (Gross)]:[Amount of Bonus Owed to Company (Gross)], [Program Type]:[Program Type], "Sign-On Bonus", Status:Status, ="Pending Initial Notification")

Thanks in advance for your help!!

Find more posts tagged with

Formulas

Accepted answers

Leibel S

@AGorgei

Something like this?

=SUMIFS([Amount of Bonus Owed to Company (Gross)]:[Amount of Bonus Owed to Company (Gross)], [Program Type]:[Program Type], "Sign-On Bonus", Status:Status, OR(@cell="Pending Initial Notification",@cell="Pending Mail Merge",@cell="Awaiting Calculation",@cell="Payment Received"))

All comments

Leibel S

@AGorgei

Something like this?

AGorgei

@Leibel S that worked! THANK YOU!!

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.