Using the method I suggested you could use:
=SQRT(DEVSQ(INDEX(Data!B:B,MATCH(B2,Data!A:A,1)):INDEX(Data!B:B,MATCH(C2,Data!A:A,1)))/(MATCH(C2,Data!A:A,1)-MATCH(B2,Data!A:A,1)+1))
which gives a result of: 0.007313
This version gives your expected result of 0.007336
=SQRT(DEVSQ(INDEX(Data!B:B,MATCH(B2,Data!A:A,1)+IF(ISNUMBER(MATCH(B2,Data!A:A,0)),0,1)):INDEX(Data!B:B,MATCH(C2,Data!A:A,1)+IF(ISNUMBER(MATCH(C2,Data!A:A,0)),0,1)))/(MATCH(C2,Data!A:A,1)-MATCH(B2,Data!A:A,1)))
Bookmarks