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

[µo°Ý] ­pºâ­«ÂÐ¥X²{ªº¤å¦r¦¸¼Æ

[µo°Ý] ­pºâ­«ÂÐ¥X²{ªº¤å¦r¦¸¼Æ

¥»©«³Ì«á¥Ñ yowrex ©ó 2014-6-9 10:51 ½s¿è

±z¦n¡A¨D§U°ÝÃD¡G

AÄæ³£¬O¤å¦r¸ê®Æ(³£¬O¤£¦P¦r¼Æ¡BµL³W«ßªº¤å¦r)
·Q­pºâAÄæ¥X²{¬Û¦P¤å¦r¸ê®Æªº¦¸¼Æ¡A¸Ó¦p¦ó°µ©O¡HÁÂÁ¡I

¦^´_ 1# yowrex

   ¥ÎCOUNTIF¥i¥H¹F¦¨§A­nªº»Ý¨D¶Ü¡H
    =COUNTIF(½d³ò,­n­pºâªº¥Ø¼Ð)

TOP

¦^´_ 2# owen06

«D±`ÁÂÁ±zªº¦^ÂСA§Ú¤S¾Ç¨ì¤@½Ò~
¤£¹L¥i¯à§Ú°Ýªº¤è¦¡¤£¤Ó¹ï
§Úªºª¬ªp¬O¡G
°²³]AÄæ¤å¦r¦p¤U¡G

¥¼¨Ó©õ¤é
¦B³·©_½t
¶ÂÅ]¤k
¶ÂÅ]¤k
©ú¤éÃä¹Ò
­ô¦N©Ô
­ô¦N©Ô
¡K(¸ê®Æ·|³v¤ékey¤J¡A¥i¯à¬O¤£¦P¼Æ¦r)

µM«á§Ú·Q³]­p¦¨¡A¨C¿é¤J¤@µ§¸ê®Æ¡A´N·|­pºâ­«ÂЦ¸¼Æ¡A
¨Ò¦p¤W¨Ò¬O­«ÂЪº¦¸¼Æ¬O¡G2(¦³¨â³¡¹q¼v­«ÂФF)
¸Ó¦p¦ó°µ¡A¤~¯à±o¨ì¡u2¡v³o­Ó­pºâµ²ªG©O¡H

TOP

¦^´_ 3# yowrex
³]¸ê®Æ¦b A2:A8
B2
=COUNTIF(A$2:A$8,A2)
¦V¤U©Ô

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2014-6-10 00:25 ½s¿è

¦^´_ 3# yowrex
«Ø¥ß¦WºÙx
=COUNTIF(OFFSET(¤u§@ªí1!$A$1,,,COUNTA(¤u§@ªí1!$A:$A),),OFFSET(¤u§@ªí1!$A$1,,,COUNTA(¤u§@ªí1!$A:$A),))
B1¤½¦¡
=SUMPRODUCT((x>1)*(1/x))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# yen956

³o¤èªk¥i¦æ¡A«D±`·PÁ±zªºÀ°¦£¡I

TOP

¦^´_ 5# Hsieh


ÁÂÁ±z¡I±z´£¨Ñªº¤èªk§¹¥þ²Å¦X§Ú­nªºµ²ªG
¬Ý¨Ó§Ú±o¦A¬ã¨s¤@¤USUMPRODUCT³o­Ó¨ç¼Æªº¥Îªk¡I

TOP

¦^´_ 5# Hsieh

Dearª©¤j¡G
·Q¤£À´why
sumproduct=((x>1)*(1/x))

¦pªG¨S¦³¥´ÂZªº¸Ü¡A¥i¥H¸ÑÄÀ¤@¤U¶Ü¡H
«Ü·Qª¾¹D¬°¤°»ò¡H
·Q«Ü¤[·Q¤£À´
sorry¸ê½è¾q¶w

ÁÂÁÂ

TOP

¦^´_ [url=0http://forum.twbts.com/redirect. ... 8294&ptid=12051]8#[/url] jj369963

x¬O±o¨ì°ÊºA½d³ò¦U­ÓÀx¦s®æ¥X²{¦¸¼Æ
Á|¨Ò¨Ó»¡
A1:A5¬°a,a,b,c,d
«hx±N¶Ç¦^2,2,1,1,1ªº¼Æ­È°}¦C
x>1«h¶Ç¦^TRUE,TRUE,FALSE,FALSE,FALSEªºÅÞ¿è­È°}¦C
1/x«h¶Ç¦^0.5,0.5,1,1,1ªº¼Æ­È°}¦C
SUMPRODUCT·|¶Ç¦^2°}¦C¬Û­¼ªº¥[Á`
«h¶Ç¦^0.5+0.5+0+0+0=1
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD