请教老师,有没有办法把“O列”的HARMEAN公式变简单? 比如“O90”单元格的公式是=HARMEAN(K62:M62,K63:M63,K64:M64,K65:M65,K66:M66,K67:M67,K68:M68,K69:M69,K70:M70,K71:M71,K72:M72,K73:M73,K74:M74,K75:M75,K76:M76,K77:M77,K78:M78,K79:M79,K80:M80,K81:M81,K82:M82,K83:M83,K84:M84,K85:M85,K86:M86,K87:M87,K88:M88,K89:M89,K90:M90),这里是29个就这么长,如果100个...那就太麻烦了,有没有办法变得简单一点? 另外,“O100”单元格的公式与上面的公式有所不同,同理有没有办法也把它变简单? =HARMEAN(K$72:M$72,K$73:M$73,K$74:M$74,K$75:M$75,K$76:M$76,K$77:M$77,K$78:M$78,K$79:M$79,K$80:M$80,K$81:M$81,K$82:M$82,K$83:M$83,K$84:M$84,K$85:M$85,K$86:M$86,K$87:M$87,K$88:M$88,K$89:M$89,K$90:M$90,K$91:M$91,K$92:M$92,K$93:M$93,K$94:M$94,K$95:M$95,K$96:M$96,K$97:M$97,K$98:M$98,K$99:M$99,K100:M100
|