Can I use Or more than once in a sumifs formula?

the formula below sums the time served column for just " SPD minor" for January and does not add zeroes to my dashboard. I would like to combine the time served for SPD Minor, SPD Major and SPD continued.

=IF(SUMIFS({N TS}, { N Intervention}, ="SPD minor", { N Date}, YEAR(@cell) = 2022, { N Date}, MONTH(@cell) = 1, { N TS}, >0) = 0, "", SUMIFS({ N TS}, { N Intervention}, ="SPD minor", { N Date}, YEAR(@cell) = 2022, { N Date}, MONTH(@cell) = 1, { N TS}, >0))

Find more posts tagged with

Accepted answers

All comments

Michael Culley

If I'm understanding correctly, you should just be able to add the different sumifs together.

=sumifs({this},"that",{this2},"that2") + sumifs({other},"thing",{other2},"thing2")

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.