For StDev function omit data in range from the calculation that is greater than a number

I want to do a standard deviation calculation that omits any numbers from the calculation that are greater than (or less than) the number in a specific cell. I have a macro to create a StDevIf function that will only use the numbers that match that criteria in the same row, but I am not sure how to modify it so that I can use a greater than (or less than) cell reference as the criteria (see code below). Also is there any way to add a new function that can be used in non-macro enabled workbooks? Thank you for your help in advance.

HTML Code: 

Hi Tony,

This worked {=STDEV(IF(B7:B39<=B2,B7:B39))}, but when I added in an AND function I ran into problems {=STDEV(IF(AND(B7:B39<=B2,B7:B39>=B3),B7:B39))}. What am I doing wrong? This is Excel 2007.

Ok got it to work: {=STDEV(IF(B7:B39>=B3,IF(B7:B39<=B2,B7:B39)))}