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

[µo°Ý] COUNTIF­pºâ¤£­«½Æ­È

[µo°Ý] COUNTIF­pºâ¤£­«½Æ­È

¥»©«³Ì«á¥Ñ PJChen ©ó 2020-2-16 12:12 ½s¿è

Dear,
§Ú¥ÎCOUNTIF­pºâ¤£­«½Æ¥X²{ªº¦¸¼Æ
=SUM(1/COUNTIF(AC$2:AC$490,AC$2:AC$490))
¦C1ªíÀY¤£­p,AC:AC©T©w¦³8­Ó¤£­«½Æ­È(ERR¤£­p),¥Î¨Ó²Î­p­q³æ¬O§_¨ì»ô

¥¿±`±¡ªp­Y­q³æ¦³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¥H­pºâ,¦Ó©T©w¤@­Ó°Ï°ì¹w³]490¦C
¤¤¶¡¤£»Ý­n³Q­pºâªº,¥HERRÅã¥Ü,¦h¥X¨Óªº¦C¼Æ¤]³£¬OÅã¥ÜERR
½Ð°Ý¦³¨S¦³¨ä¥L¤è¦¡¥i¥H¬¡°Ê­pºâAC:ACªº¤£­«ÂЭÈ,¦ý¤£­n¹w³]¦C¼Æ??

COUNTIF_­pºâDC¬O§_»ô¥þ.rar (17.75 KB)

°}¦C¤½¦¡:
=COUNT(0/(MATCH(AC2:AC490,AC:AC,)=ROW(2:490))/(AC2:AC490<>"ERR"))

TOP

¦^´_ 2# ­ã´£³¡ªL

·PÁÂ,°õ¦æµL»~^^

TOP

¦^´_ 2# ­ã´£³¡ªL

½Ð±Ðª©¥D¡A¦pªGACÄæ¦ì§ï¬°¤é´Á¡A±ø¥ó¤@¼Ë½Ð°Ý­n¦p¦ó­×§ï¡AÁÂÁ¡C

TOP

¦^´_ 4# samwang


=COUNT(0/FREQUENCY(AC:AC,AC:AC))

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD