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

Ãö©ó¾Ç¥Í¨îªA¤Ø¤o¹ï·Ó°ÝÃD¤S¨Ó¨D±ÏÅo ....

Ãö©ó¾Ç¥Í¨îªA¤Ø¤o¹ï·Ó°ÝÃD¤S¨Ó¨D±ÏÅo ....

Ãö©ó¾Ç¥Í¨îªA¤Ø¤o¹ï·Ó°ÝÃD¤S¨Ó¨D±ÏÅo ....

1.«ç»òÅý¤p¼ÆÂI¦Û°Ê¥|±Ë¤­¤J©O ...

2.¹ï·Ó«á¶ñ¤W¼Æ¦r§ÚÁÙ¥i¥H¥Î SUMPRODUCT ..­n¶ñ¤W¦r¥À­n¥Î¨º£¾­Ó©O ....¨D¦U¦ì¤j¤jÀ°¦£

test.rar (4.2 KB)
jacky

¦^´_ 1# chouj

TOP

¦³³W«h¶Ü ? «ç»ò¤p¼ÆÂI¦Û°Ê¥|±Ë¤­ªk©O ?

²q¤@²q

D2 °}¦C¤½¦¡

{=INDEX(¤Ø¤o¹ï·Ó!C$3:C$185,MATCH(1,(¤Ø¤o¹ï·Ó!A$3:A$185>=B2)*(¤Ø¤o¹ï·Ó!B$3:B$185>=C2),))}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD