I have tried: =and(a:a<=e3,a:a>e4)stdev(c:c)
Array-enter the following formula (
press ctrl+shift+Enter instead of just Enter):
<a1:a40000,if(a1:a40000<=e3,c1:c40000)))
<a1:a40000,if(a1:a40000<=e3,c1:c40000)))
</a1:a40000,if(a1:a40000<=e3,c1:c40000)))
</a1:a40000,if(a1:a40000<=e3,c1:c40000)))
=STDEV(IF(A1:A40000<=E3,IF(A1:A40000>E4,C1:C40000)))<a1:a40000,if(a1:a40000<=e3,c1:c40000)))
<a1:a40000,if(a1:a40000<=e3,c1:c40000)))
</a1:a40000,if(a1:a40000<=e3,c1:c40000)))
<a1:a40000,if(a1:a40000<=e3,c1:c40000)))
</a1:a40000,if(a1:a40000<=e3,c1:c40000)))
<a1:a40000,if(a1:a40000<=e3,c1:c40000)))
although I might use STDEVP instead of STDEV in this case.</a1:a40000,if(a1:a40000<=e3,c1:c40000)))
Note that I use A1:A40000 instead of A:A. The latter forces Excel to process and create temp arrays of over 1 million entries. If you have "daily data over many years", you have much fewer rows of data.</a1:a40000,if(a1:a40000<=e3,c1:c40000)))