- ©«¤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)
 |   
 
 
 
 |