How to change formula for more then one criteria

Sara Moore

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.

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

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