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
-
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.
-
Awesome. Please accept my answer and have a great evening, day, etc! :D
Answers
-
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
-
Awesome. Please accept my answer and have a great evening, day, etc! :D
Help Article Resources
Categories
Check out the Formula Handbook template!