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

[µo°Ý] sumproduct¨ç¼Æªº¸Ñ©Ç©Çªº

[µo°Ý] sumproduct¨ç¼Æªº¸Ñ©Ç©Çªº

¥»©«³Ì«á¥Ñ eghost ©ó 2014-12-11 20:13 ½s¿è

¦U¦ì¥ý¶i¡A¤p§Ì¦b¨Ï¥Îsumproduct¨ç¼Æªº®É«J¦³­Ó°ÝÃD¡A
§Ú¦³°µ¤F¤@­Óªí®æ¡A­n²Î­p¼t¤º¦U¤ë¥÷¾÷¥x¹w¥X/¤w¥X¼Æ¶q¡A¦p¤U¹Ï¡G



ªí¤º¤ë¥÷¥i¿ï¾Ü¡A¦ý¿ï¾Ü1¤ëªº®É«J¡A§Úªº¥X¾÷¤é´Á©ú©ú¬OªÅ¥Õªº¡A¬°¤°»ò·|­pºâ¥X¼Æ¶q?



¦Ó¥B¥u¦³¿ï1¤ëªº®É«J·|¦³¿ù»~¡A¨ä¥L¤ë¥÷³£¨S¦³°ÝÃD¡C
¥i¥H½Ð­þ§Ú°ª¤âÀ°§Ú¬Ý¤@¤U­þ¸Ì¥X¿ù¤F¶Ü?
ªþ¤WÀɮסC
´ú¸Õ¥Î.rar (21.92 KB)

¦^´_ 1# eghost

    ªÅ®æµø¬° 0
    MONTH(0) = 1
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 1# eghost

Á`ªí»P»s¥O³æªº¾÷ºØ¦WºÙ­n¤@­P¡A´N¥i¥H²¤Æ¤½¦¡¡A¦p¤U¹Ï

C4¤½¦¡¥i¥H¥k©Ô¤U©Ô½Æ»s¤½¦¡¡A¤@­Ó¤½¦¡§¹¦¨¥þ³¡Á`­p
ªÅ®æ©ó­pºâ®É·|µø¬° 0¡A¦]¦¹ MONTH(0) = 1 ³y¦¨1¤ë¥÷­pºâ¿ù»~

   
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# ML089


­ì¨ÓMONTH(0)=1...®`§ÚÀY³£§Ö§ì¯}¤F!
¤S¾Ç¨ì¤F¡A·PÁª©¥D

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD