| ©«¤l913 ¥DÃD150 ºëµØ0 ¿n¤À1089 ÂI¦W0  §@·~¨t²Îwin10 ³nÅ骩¥»office 2019 ¾\ŪÅv50 ©Ê§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) | 
 |