¦U¦ì¦n,
·Q½Ð°Ý¤@¤U,
°ÝÃD1 : ¦bq³æ¶i«×ªíªºCÄæ, §Ú·QnÅã¥Üq³æª÷ÃB, §Y¬O²Îp¦bq³æ±Æµ{¸Ìªº¼Æ¶q«á, µM«á©M»ù®æªí®æ¸Ì»ù®æ¥[Á`
¤§«e¦³¦b³o¸Ì°Ý¹L¤@Ó¨ç¼Æ¥i¥H³B²z, ½Ð¬Ý¤U¦C"¨ç¼Æ1", ¦ý§Ú²{¦bªº°ÝÃD¬O, ¦bq³æ·|¤@ª½©¹¤U¼W¥[ªº,¥H¤Î
»ù®æÁ`ªí¬O·|¦]¬°¤é´Á¤£¦PÅܰʪº, ¨Ò¦p ¤µ¤Ñ2013/03/22, ©Ò¦³²£«~³£§ó·s»ù®æ¤F, ¨º¦b³oÓ¤é´Á¤§«áq³æ, ´Nn¥Î·s»ù®æ,
³Â·Ð¬O, §Ún¤£Â_ªº¦b"¨ç¼Æ1"¥[¤J¤é´Á¤ñ¹ï, ¤~¯à¥[Á`, ¬O§_¦³¨ä¥L¨ç¼Æ¥i¥H¦Û¦æ¶i¦æ¤é´Á¤ñ¸û?
«ÂI¬Oif¨ç¼Æ¤]µLªkµLªº¥[¤U¥h..
°ÝÃD2 ¸ò²Ä¤@Ó°ÝÃD¤]¦³ÂI¹³, ¦bq³æ±Æµ{ªºFÄæ, n§ä¥X»ù®æ, ¦]¬°»ù®æ¤]¬OµL¥[¤U¥hªº, §Ú¤§«e¥Îªº¨ç¼Æ¤]¤£¾A¥Î, ½Ð¨£¨ç¼Æ2
¥ýÁÂÁ¦U¦ì¤F!!
¨ç¼Æ1:
=IF(B26="","",SUMPRODUCT(N(OFFSET(IF(AND(¤U³æ¤é´Á>SCDate_121118,¤U³æ¤é´Á<SCDate_130102),SC_Price121118,IF(AND(¤U³æ¤é´Á>SCDate_130102,¤U³æ¤é´Á<SCDate_130214),SC_Price130102,SC_Price130320)),MATCH(z,»ù®æÁ`ªí!$C$3:$C$39,)-1,))*y*(B26=x)))
¨ç¼Æ2:
=IF(AND(TEXT(B3,"yyyymmdd")>TEXT(»ù®æÁ`ªí!$H$1,"yyyymmdd"),TEXT(q³æ±Æµ{!B3,"yyyymmdd")<TEXT(»ù®æÁ`ªí!$I$1,"yyyymmdd")),VLOOKUP(q³æ±Æµ{!D3,»ù®æÁ`ªí!$C$2:$K$20,6,0),VLOOKUP(q³æ±Æµ{!D3,»ù®æÁ`ªí!$C$2:$K$20,7,0))
°ÝÃD.rar (185.7 KB)
|