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

EXCEL2010¦p¦ó¥[Á`®æ¦¡¤Æ±ø¥ó[ÃC¦â]½d³òÀx¦s®æ

EXCEL2010¦p¦ó¥[Á`®æ¦¡¤Æ±ø¥ó[ÃC¦â]½d³òÀx¦s®æ

¥»©«³Ì«á¥Ñ jackson7015 ©ó 2012-4-20 08:52 ½s¿è

½Ð°Ý¦U¦ì«e½ú
°²³]A5:A1000¬Ò¦³¦U¦Û¤½¦¡¤º®e,©M¨âºØÃC¦â®æ¦¡¤Æ±ø¥ó
¦p¦ó¦bA1§PÂ_A5:A1000ªº®æ¦¡¤Æ±ø¥ó¶ñº¡ÃC¦â[¬õ¦â(R255;G0;B0)]ªºÁ`©M¼Æ¶q
¥t¤@ºØ±`¸mªº®æ¦¡¤Æ±ø¥óÃC¦â¬°²LÂÅ(R218;G238;B243)

§Ú°Ñ¦Ò¹L¥HGET.CELL°µ§PÂ_,¦ý¬O¦b¤U¥\¤O¤£°÷..
ÁÙ¬O¼g¤£¥X¨Ó
§Æ±æ¦³¤j¤j¯àÀ°¦£¸Ñ´b,·PÁ ¡I

¦^´_ 1# jackson7015

¬¡°Ê¼s§i:
1.µo°ÝªÌ½Ð¤W¶ÇEXCELÀ£ÁYÀÉ(¤p¾Ç¥Í¤]¥i¥H)
2.°t¦XEXCELÀɽЧâ¥\¯à»¡©ú²M·¡


=>¨Ï¥ÎGET.CELLÁôÂèç¼Æ(¶·°t¦X©w¸q)(À³¸Ó¸û³Â·Ð)
   
1.jpg
2012-4-20 17:54


=>¨Ï¥Î³]©wÃC¦â¤§®æ¦¡¤Æ±ø¥ó(À³¸Ó¸û®e©ö)
    ???

TOP

¥»©«³Ì«á¥Ñ jackson7015 ©ó 2012-4-23 09:16 ½s¿è

¦^´_ 2# register313

¥ý·PÁÂregister313 ¤j¤j ªº¦^À³
­«·sªþ¤WEXCELÀÉ®×»¡©ú
ºî¦X¸ê®Æ®w.rar (53.67 KB)

¦b³]©w©w¸q«á,¿é¤J¤½¦¡¦³¥X²{¿ù»~

­Y¬O¤£¨Ï¥ÎVBA©M»²§UÄæÀx¦s®æ±¡ªp¤U
¯à§_¥u¦bA1³æ®æ­pºâ¥X¬õ¦âÀx¦s®æªº¼Æ¶q ?

TOP

¦^´_ 3# jackson7015
=SUMPRODUCT(((C5:C300<1)+(D5:D300<1))*(F5:F300>0))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh

·PÁÂHsiehª©¥Dªº¦^À³
Åý¤p§Ì¦³¥t¤@­Ó«ä¦Ò¤è¦V
¤½¦¡¤w¸g¯à¥¿±`¹B§@

¤£¬O¥H®æ¦¡¤Æ±ø¥ó°µ§PÂ_
«o¬O¥H®æ¦¡¤Æ±ø¥ó¤½¦¡¨Ó°µ§PÂ_
¤£¶·¦A§Q¥Î®æ¦¡¤Æ±ø¥ó°µ¸õªO¦A¥t§@¤½¦¡

TOP

¦^´_ 4# Hsieh
·Q¨D±ÐHsiehª©¥D

®æ¦¡¤Æ±ø¥ó¤½¦¡¬O
=AND($I5>0,OR($Q5<1,$R5<1,$T5<1,$U5<1,$V5<1,AND($K5+$L5+$M5+$N5)<1))
½d³ò¬O
=$A$5:$A$300

½Ð°Ý­YÂà´«¦¨SUMPRODUCT¤½¦¡¼gªk¬O­þ¸Ì¼g¿ù¤F©O
=SUMPRODUCT((I5:I300>0)*((Q5:Q300<1)+(R5:R300<1)+(T5:T300<1)+(U5:U300<1)+(V5:V300<1)+((K5:K300<1)*(M5:M300<1)*(N5:N300<1)*(L5:L300<1)))

TOP

¦^´_ 6# jackson7015

¬¡°Ê¼s§i:À°§U¦Û¤v!¤]µ¹µªÃDªÌ¤@­Ó¤è«K!
1.µo°ÝªÌ½Ð¤W¶ÇEXCELÀ£ÁYÀÉ(¤p¾Ç¥Í¤]¥i¥H)
2.°t¦XEXCELÀɽЧâ¥\¯à»¡©ú²M·¡

TOP

¦^´_ 7# register313

ªþ¤W·sÀÉ®×»¡©ú
¥[Á`±ø¥ó®æ¦¡(ÃC¦â).rar (16.8 KB)

±ø¥ó®æ¦¡ªº¤½¦¡¥HSUMPRODUCT§ï¼g
¸õ¹L¥HÃC¦â°µ§PÂ_
ª½±µ¥H®æ¦¡¤Æ±ø¥óªº¤½¦¡§ï¬°SUMPRODUCT¨ÓÁ`©M
¦ý¬O§ï¤F¦h¦¸¦n¹³³£¬O¿ù»~ªº
§Æ±æ«e½ú­ÌÀ°¦£­×§ï

TOP

¦^´_ 8# jackson7015

´ú¸Õ¬Ý¬Ý

°}¦C¤½¦¡
=SUM((I5:I300>0)*(IF((K5:K300&L5:L300&M5:M300&N5:N300="")+(Q5:Q300="")+(R5:R300="")+(T5:T300="")+(U5:U300="")+(V5:V300="")=0,0,1)))

°}¦C¤½¦¡
=SUMPRODUCT((I5:I300>0)*(IF((K5:K300&L5:L300&M5:M300&N5:N300="")+(Q5:Q300="")+(R5:R300="")+(T5:T300="")+(U5:U300="")+(V5:V300="")=0,0,1)))

TOP

¦^´_ 9# register313

·PÁÂregister313¤j¤jªº¦^À³
¨â­Ó¤½¦¡³£¥i¥H¥¿±`¨Ï¥Î

ÁÂÁ¦U¦ì«e½úªºÀ°¦£
¤½¦¡¥i¥H¥¿±`¹B§@¤F

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD