How to change formula for more then one criteria

So this formula works for me. I am trying to add another criteria though and cant figure it out.

=SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Stained")

And it works but i want it to add the "stained" and "staining in progress" in the same column. how to i rewrite the formula in order for it to do this? "Staining in progress" is also listed as an option in the same status column.

Find more posts tagged with

Sheets

IT & Operations

Account and User Management

Accepted answers

Mike Wilday

Try this one:

=SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, OR(@cell = "Stained", @cell = "Staining in progress"))

That should do the trick for you.

Mike Wilday

Awesome. Please accept my answer and have a great evening, day, etc! :D

All comments

Mike Wilday

Try this one:

=SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, OR(@cell = "Stained", @cell = "Staining in progress"))

That should do the trick for you.

Sara Moore

Thank you! that worked

Mike Wilday

Awesome. Please accept my answer and have a great evening, day, etc! :D

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.