- ©«¤l
- 913
- ¥DÃD
- 150
- ºëµØ
- 0
- ¿n¤À
- 1089
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- office 2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-8-28
- ³Ì«áµn¿ý
- 2023-7-19
|
¥»©«³Ì«á¥Ñ PJChen ©ó 2020-2-16 12:12 ½s¿è
Dear,
§Ú¥ÎCOUNTIFpºâ¤£«½Æ¥X²{ªº¦¸¼Æ
=SUM(1/COUNTIF(AC$2:AC$490,AC$2:AC$490))
¦C1ªíÀY¤£p,AC:AC©T©w¦³8Ó¤£«½ÆÈ(ERR¤£p),¥Î¨Ó²Îpq³æ¬O§_¨ì»ô
¥¿±`±¡ªpYq³æ¦³100¦C,AC:AC´N¥u·|¥X²{100¦C,¥Ñ©ó¨C¤Ñªºq³æ¦C¼Æ«D©T©wªº,
¬°¤F¨Ï"=SUM(1/COUNTIF(AC$2:AC$490,AC$2:AC$490))"¥i¥Hpºâ,¦Ó©T©w¤@Ó°Ï°ì¹w³]490¦C
¤¤¶¡¤£»Ýn³Qpºâªº,¥HERRÅã¥Ü,¦h¥X¨Óªº¦C¼Æ¤]³£¬OÅã¥ÜERR
½Ð°Ý¦³¨S¦³¨ä¥L¤è¦¡¥i¥H¬¡°ÊpºâAC:ACªº¤£«ÂÐÈ,¦ý¤£n¹w³]¦C¼Æ??
COUNTIF_pºâDC¬O§_»ô¥þ.rar (17.75 KB)
|
|