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

[µo°Ý] ²Î­p¦¸¼Æ°ÝÃD

[µo°Ý] ²Î­p¦¸¼Æ°ÝÃD

Àɮפ¤¦³¤@¦C¼Æ¾Ú¡A
§Ú·Q­n§Q¥Î¨ç¼Æ²Î­p¥X«á­±¼Æ¾Ú´î¥h«e­±¼Æ¾Ú §e²{¥¿¼Æªº¦¸¼Æ

¨Ò¦p: 4   ¡B 1¡B 1¡B  2¡B   5

¥X²{ªº¦¸¼Æ¬°2¦¸!


Book1.rar (3.03 KB)

¦^´_ 1# gtonancy


¤p¾Ç¥Í¨Sªk¤U¸üÀÉ®×
°²³]±zªº¸ê®Æ°Ï¶¡¦bA1~E1
=SUMPRODUCT(--((B1:E1-A1:D1)>0))
My Blog
http://blog.xuite.net/a8350070

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD