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.
Popular Tags:
0
Best 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.
0
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