excel ¶W¹LÃB«×ªº´£¿ô

joyce9999

excel¬O§_¥i°µ¨ì
§Ú¥ý¦bsheet1³]©w¤ý¤p©úªºÃB«×¬°100¤¸

¦Ósheet2¶}©l¨C¤Ñµn°O©Ò¥Îªº¿ú¬°

   A(©m¦W)  B(¤é´Á)  C(ª÷ÃB)
  ¤ý¤p©ú     4/1       20
  ´¿¤j¤è     4/1       30
  ¤ý¤p©ú     4/2       30
  ¤ý¤p©ú     4/3       40
  ¶À¤p·|     4/4       30
  ¤ý¤p©ú     4/4       25    ®É  ¦]¶W¹L¥LªºÃB«×100¦Ó²£¥Íĵ§i

¥iĵ§i¦¨---
1. ¦¹®æ±N±j­¢Åܦ¨10 (º¡ÃB«×) ¨Ã¼Ð¥Ü¬°¬õ¦â
2. ©Î¬OµLªkÁä¤J10¥H¤Wªº¼Æ¦r
3. ©Î¬OÁä¤J¶W¹L10¥H¤W¼Æ¦r®É²£¥Í¬õ©³¨Ã¥H¥ô¦ó¤è¦¡Äµ§i¶W¹LÃB«×

yanto913

[i=s] ¥»©«³Ì«á¥Ñ yanto913 ©ó 2011-4-12 16:16 ½s¿è [/i]

¥\¯à2.
¿ï¨ú½d³òC2:C32
¨Ï¥Î¥\¯àªí¤Wªº[¸ê®Æ]¡÷[ÅçÃÒ]¡÷[³]©w]
Àx¦s®æ¤º¤¹³\¿ï[¦Û­q]
[¤½¦¡]=SUM(C2:C32)<=100
¦b¿ù»~´£¿ô¤º¥i³]©w´£¿ô°T®§

joyce9999

¦^´_ 2# yanto913


   dear yoyo

¦pªG»¡!``A ¤£¥þ¬O¤ý¤p©úÁÙ¦³¬ï´¡§O¤H
¦³¿ìªk¿ëÃÑ¥X~~·í¤ý¤p©ú¶W¹Lªº¨º¤@µ§¡A¦Ó´£¥Xĵ§i¶Ü?

Hsieh

¦^´_ 3# joyce9999


   

¤U¸ü (13.77 KB)

2011-4-12 17:38

joyce9999

¦^´_ 4# Hsieh


    ¦Ñ®v¡G±zªº·N«ä¬O¦bC2¼g¤JSUMPRODUCT....ªº¨º¤@¦ê¤½¦¡¶Ü?  C2Áä¤J«á~~¥X²{TRUE??

     ¥i¬OC2 ­nÁä¤J¼Æ¦r!!

Hsieh

¦^´_ 5# joyce9999

1.¿ï¨úC2Àx¦s®æ
2.¤u¨ã/¸ê®Æ/ÅçÃÒ
3.¦p¹Ï¿é¤J¤½¦¡
4.½Æ»sC2Àx¦s®æ
5¿ï¨úCÄæ¡A¿ï¾Ü©Ê¶K¤W/ÅçÃÒ

¤U¸ü (29.47 KB)

2011-4-12 22:32

joyce9999

¦^´_ 5# joyce9999


    ¨þ¨þ¨þ~~~¦Ñ®vÁÂÁÂ!``§ÚÀ´¤F!`` ¸ê®ÆÅçÃÒ~~ ¦nÁÂÁ¦Ѯv³á~¯u¼F®`

yanto913

=SUMPRODUCT(--($A$1:$A2=$A2),($C$1:$C2))<=VLOOKUP($A2,$G$1:$H$3,2,0)

rph

©êºp!§Ú§Ñ°O"--"ªº·N«ä¬O???
¥i§_¦A»¡1¦¸SUMPRODUCT(--.........),©Ò¿×ªº"--"¥Nªí¬O??
­ì¨ÓSUMPRODUCTªº¥ÎªkÁÙ¥i¥H³o¼Ë¥Î!

rph

§Ú¤w¸g¾\Ū¤F
·PÁÂHsiehª©¥Dªº´£¿ô