Just like the other formulas

=(AVERAGE(IF(B49:B276<B2,B49:B276))/STDEV(IF(B49:B276<B2,B49:B276)))*SQRT(12)

All of these are array formulas that must be array entered. If there
are blank cells in B49:B276, then you would need to expand to

=(AVERAGE(IF(ISNUMBER(B49:B276)*(B49:B276<B2),B49: B276))/STDEV(IF(ISNUMBER(B49:B276)*(B49:B276<B2),B49:B276 )))*SQRT(12)

to keep empty cells from being interpreted as zeros.

Jerry

Zeelotes wrote:

Do you have any suggestions on how to convert the Sharpe formula so that it
can include the IF statement that I require? Thanks for the fantastic
solution to the GSD formula.