Ignore blank cells in STDEV function?

[NoETA]

I have an array which includes some blank cells. I want to take the AVERAGE and STDEV of the array ignoring the blank cells.

I figured out how to do that with =AVERAGEIF(D8:D84,">0") and it seems to work, but I can’t figure out how to do it with STDEV. Any ideas? Is there a corresponding =STDEVIF(D8:D84,">0") ?

[anon73440385]

Hello

AVERAGE and STDEV ignore blank cells, so no “IF”-test required at all.

See image:

My version is:

Version: 6.2.2.2
Build ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d
CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde5;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded