Need some help with this STDEV formula

[Peter h]

Hello. I've got this formula that I use to give me the STDEV of all data in column "E" from the previous month. It works just as it should, but I was wondering if there is any way to change it to exclude blank cells. Right now, if the cell is blank it calculates it as 0, and it throws off my calculation. Here's my formula:

{=ROUND(STDEV.P(IF(($D$7:$D$10000>EOMONTH(TODAY(),-2))*($D$7:$D$10000<eomonth(today(),-1)+1,e7:e10000)),3)}<eomonth(today(),-1)+1),e7:e10000)),3)}


<eomonth(today(),-1)+1),e7:e10000)),3)
<eomonth(today(),-1)+1),e7:e10000)),3)}
<eomonth(today(),-1)+1),e7:e10000)),3)}

<eomonth(today(),-1)+1),e7:e10000)),3)}

<EOMONTH(TODAY(),-1)+1),E7:E10000)),3)}

Thanks <eomonth(today(),-1)+1),e7:e10000)),3)}



</eomonth(today(),-1)+1),e7:e10000)),3)}
</eomonth(today(),-1)+1),e7:e10000)),3)}
</eomonth(today(),-1)+1),e7:e10000)),3)}
</eomonth(today(),-1)+1),e7:e10000)),3)}
</eomonth(today(),-1)+1),e7:e10000)),3)


Edit: I cannot get the whole formula to save in the post. Anyone have any ideas why?</eomonth(today(),-1)+1,e7:e10000)),3)}<eomonth(today(),-1)+1),e7:e10000)),3)}

 

[Domenic]

A less than symbol ( < ) get's interpreted as the start of HTML code. Therefore, try leaving a space after a < . Actually, I usually leave a space before and after a < .

 

[Peter h]

Here's the formula:

{=ROUND(STDEV.P(IF(($D$7:$D$10000>EOMONTH(TODAY(),-2))*($D$7:$D$10000< EOMONTH(TODAY(),-1)+1),E7:E10000)),3)}

Thanks Domenic !!

 

[Domenic]

Try...

=ROUND(STDEV.P(IF(($D$7:$D$10000>EOMONTH(TODAY(),-2))*($D$7:$D$10000 < EOMONTH(TODAY(),-1)+1),IF(E7:E10000<>"",E7:E10000))),3)

...confirmed with CONTROL+SHIFT+ENTER.

 

[Peter h]

Try...

=ROUND(STDEV.P(IF(($D$7:$D$10000>EOMONTH(TODAY(),-2))*($D$7:$D$10000 < EOMONTH(TODAY(),-1)+1),IF(E7:E10000<>"",E7:E10000))),3)

...confirmed with CONTROL+SHIFT+ENTER.

That did the trick. Thank you very much.