Sumif one of criteria is met - or countif?

NicoleB

I have a column of data that I would like to Sum if different criteria are met -

here is an example -

Sumif = x or y or z

Sumif = a or b or c

I'm trying to Sum or count

Tried a few formulas so far

=SUMIFS({INT/EXD - Stage}, "Not Started", or [{INT/EXD

- Stage}, "IDD Started", or {INT/EXD - Stage}, "As - Is

Documentation completed")

I've also tried with Countif and moved the OR around

thanks

Find more posts tagged with

Accepted answers

Mike TV

@NicoleB

=COUNTIFS({INT/EXD - Stage}, OR(@cell = "Not Started", @cell = "IDD Started", @cell = "As - Is Documentation completed"))

All comments

Mike TV

@NicoleB

=COUNTIFS({INT/EXD - Stage}, OR(@cell = "Not Started", @cell = "IDD Started", @cell = "As - Is Documentation completed"))

NicoleB

~~no - I get #unparseable~~

Tried it again and it worked! Thanks

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.