Excel 2007 Standard Deviation of non-contiguous ranges with max and min removed

[drewzilla652]

I have a spreadsheet where I am trying to calculate the STDEV of numbers in a non-contiguous range, with the MAX and MIN numbers taken out.
I've named the non-contiguous range, as noted in the sample below, but I'm getting a #VALUE error. the range "month1" in the sample below, includes two columns of data (months 1 and 13).
THANK YOU! in advance for any help.

=STDEVP(IF(month1<>MAX(month1),IF(month1<>"",IF(month1<>MIN(month1),month1))))

 

[Domenic]

Try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER...

=IF(COUNT(MyRange)>3,STDEVP(SMALL(MyRange,ROW(INDIRECT("2:"&COUNT(MyRange)-1)))),"N/A")