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.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!