Conditional stdev function in Numbers?

by Rain   Last Updated July 11, 2019 22:12 PM

If I have a set A of numbers in Numbers (hah), I can use averageifs to calculate the average of the subset of A which satisfies certain conditions.

For example: Say I have the following table:

enter image description here

If I then type


into another cell, it will calculate the average of the cells of column A which satisfy the following conditions:

  • is lesser than or equal to 3
  • the cell of column B in the same row is greater than 5

Only the cells in rows 1 and 6 satisfy both conditions, so the result is the average of those two cells (1.5).

I'd like to do the same thing with the standard deviation. However, there is no stdevifs function. There is a sumifs function, so I figured I could just type something like


(assuming the conditional average calculated above is in C1), but I get an error; apparently sumifs only wants me to type in cells (e.g. A), not equations involving cells (e.g. (A-$C$1)^2).

Is there a way around this without creating new columns with commands such as =if(and(A1<=3,B1>5),(A1-$C$1)^2,"") and using those columns for the calculation?

If it helps, I'm using Numbers 6.1 on macOS 10.14.4.

Thanks in advance.

Tags : numbers iwork

Related Questions

Updated July 12, 2016 08:05 AM

Updated March 12, 2017 16:12 PM

Updated April 09, 2017 09:12 AM

Updated June 20, 2017 13:12 PM

Updated June 04, 2015 22:05 PM