I have 5 cells that contain numbers that will either pass or fail depending on acceptance criteria. I need to calculate the standard deviation of the first 3 of those cells that pass the criteria. I know that I could use a bunch of IF statements and capture all 10 possible combinations of the 5 cells but I was hoping there was a little more elegant way of solving it.
Bookmarks