Ask Your Question

Ignore blank cells in STDEV function?

asked 2019-04-17 00:35:40 +0200

No ETA gravatar image

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") ?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-04-17 11:25:03 +0200

Opaque gravatar image

updated 2019-04-17 11:52:22 +0200


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

See image:

image description

My version is:

Version: 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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-04-17 00:35:40 +0200

Seen: 28 times

Last updated: Apr 17