How to change formula for more then one criteria

01/18/21
Accepted

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

  • Mike WildayMike Wilday ✭✭✭✭✭
    Accepted Answer

    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 WildayMike Wilday ✭✭✭✭✭
    Accepted Answer

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

Answers

  • Mike WildayMike Wilday ✭✭✭✭✭
    Accepted Answer

    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.

  • Thank you! that worked

  • Mike WildayMike Wilday ✭✭✭✭✭
    Accepted Answer

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

Sign In or Register to comment.