=AVERAGE(IF(Sheet1!$H$2:$H$6728 = "A", IF(Sheet1!$J$2:$J$6728 > 0.0523, IF(Sheet1!$K$2:$K$6728 > -0.0674, IF(Sheet1!$K$2:$K$6728 < -0.0156, Sheet1!$AA$2:$AA$6728, ""), ""), ""), ""))-D$8
you'll note the fluid simplicity of ,""), ""), ""), "")). it's the kraut-rock of excel functions.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment