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

[µo°Ý] Excel ­pºâ¤£­«½Æ¦¸¼Æ¡A¦p¦ó©¿²¤ªÅ¥ÕÄæ¦ì

[µo°Ý] Excel ­pºâ¤£­«½Æ¦¸¼Æ¡A¦p¦ó©¿²¤ªÅ¥ÕÄæ¦ì

¥»©«³Ì«á¥Ñ jsc0518 ©ó 2022-2-20 13:29 ½s¿è

Dear ¦U¦ì¡A
§Ú¦bºô¸ô¤W¦³¬Ý¨ì¤U¦C¤½¦¡¡G
¥i¥H­pºâB2~B10Äæ¦ìªº¶µ¥Ø(¤£­«Âжµ¥Ø)¦@¦³¦h¤Ö¡C
=SUMPRODUCT((1/COUNTIF(B2:B10,B2:B10)))

¦ý§Ú¦bBÄæ¦ìªº¸ê®Æ¬O·|¦hªº©Î¬OÅܤÖ(«D©T©w¸ê®Æµ§¼Æ)¡A§Ú§âB2:B10½d³ò­È¡A§ï¦¨B11~B10000¡A¸Ó¤½¦¡´N¥X²{¿ù»~(¦]B11~B10000¬°ªÅ¥Õ)
§Ú­n¦p¦ó­×­q©O¡H
Just do it.

{=SUM(IFERROR(1/COUNTIF(B:B,B11:B10000),))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522
Dear hcm19522 ±z¦n,
§Ú¦³ªþ¥[ÀɮסA¥i¥HÀ°§Ú¬Ý¤@¤U¶Ü¡H
·PÁ±z
001.rar (7.78 KB)

Noname.jpg
2022-2-20 16:32
Just do it.

TOP

{=SUM(IFERROR(1/COUNTIF(B:B,B2:B10000),)) ¤TÁä¤@°_«ö
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522
Ctrl +Shift +Enter

¦p¤Uµe­±

Noname.jpg
2022-2-20 17:39
Just do it.

TOP

¦^´_  hcm19522
Ctrl +Shift +Enter

¦p¤Uµe­±
jsc0518 µoªí©ó 2022-2-20 17:39



    A11 §ï A2 ¸Õ¸Õ ~~~~
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 6# hcm19522
OK¤F¡A¤Ó·PÁ±zªº¸Ñ´b¡A·P®¦¡I¡I
Just do it.

TOP

¤½¦¡
  1. =SUMPRODUCT((A2:A65536<>"")/COUNTIF(A2:A65536,A2:A65536&""))
½Æ»s¥N½X
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 8# zz5151353
Dear zz5151353,
¦­¦w¼Ú¡A·PÁ±zªº¼ö¤ß¦^´_¡A¥i¥H¨Ï¥Î¡I·P®¦¡I
Just do it.

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD