So, I'm trying to do some varying calculations and I've gotten my average to work fine, but I need to do standard deviation based on the same criteria.
Column A is the one I need to do the deviation on
Column B is the criteria column, if it is X or Y, then I need to do the deviation based on that for Column A
Then, I need to do the deviation on the remaining that isn't X or Y (This is simple enough to do if I can just get the first working)
My average is calculated as such: =AVERAGEIFS(A:A, B:B, {"X","Y"})
It doesn't appear that I can do STDEVP based on the same multiple criteria, like I was hoping...that or it's late, and I've been staring at spreadsheets for 12+ hours already today
Thanks in advance!
Bookmarks