ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°Ý ¥i¥H¦A²¤Æ¤@¨Ç¶Ü?? ¥­§¡­È(§ï°Ñ¼Æ)

[µo°Ý] ½Ð°Ý ¥i¥H¦A²¤Æ¤@¨Ç¶Ü?? ¥­§¡­È(§ï°Ñ¼Æ)

½Ð°Ý ¥i¥H¦A²¤Æ¤@¨Ç¶Ü??     (¦]¬° ÁÙ¦³¦n´X²Õ¤U¡A·|¨ÏÀÉ®×Åܤj)

½Ð¦U¦ì¤j¤j ¤£¥O½ç±Ð!!
¥­§¡­È(§ï°Ñ¼Æ) $J$1
J3=IF((COUNTIF(F$3:F3,">=0"))<=$J$1,AVERAGEA(F$3:F3),AVERAGEA(INDIRECT("C"&(COUNTIF(F$3:F3,">=0")-($J$1)),1):F3))

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

这个¬O¦h§Eªº吗¡H
  1. ,1
½Æ»s¥N½X
¤j·§没¦³简¤Æ
  1. =IF(SUM((F$3:F3>=0))<=$J$1,AVERAGEA(F$3:F3),AVERAGEA(INDIRECT("C"&(SUM((F$3:F3>=0))-$J$1)):F3))
½Æ»s¥N½X
¦V°ª¤â学习

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD