Hi, I have a question regarding the dollar $. Below there are two formulae to calculate the standard deviation. For the first one, there is no dollar sign for C10:C45, but there is for the second one $A$10:$A$389.

={STDEV(IF(ISNUMBER(C10:C45),C10:C45-E10:E45,""))*SQRT(12)}

={STDEV(IF($A$10:$A$389>=B5,C10:C389,""))*SQRT(12)}

If I remove the dollar $ for the second one, then the error #ERROR occurs.


Thanks a lot!