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

¦WºÙ½d³ò­n²Å¦X5­Ó±ø¥óªº³]©w

¦WºÙ½d³ò­n²Å¦X5­Ó±ø¥óªº³]©w

ªþ¥óA~JÄ欰¸ê®Æ,
O7Àx¦s®æ²Å¦XA~JÄ椤ªº5­Ó±ø¥óªº¥[Á`¼Æ Book3.zip (8.4 KB)
1.2011
2.February
3.BU
4.Sales Discount&Rebate
5.ACT
¦Ó¥B·íN5 §ï¬°CU®É,O7ªº¼Æ¦r·|¦Û¤v§ïÅÜ
½Ð°Ý­n¦p¦ó³]©w"°ÊºA¦WºÙ"?

¦^´_ 1# VANESSA
¸Õ¸Õ¬Ý
Book3.rar (7.83 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

½Ð°Ý¬°¤°»ò§Ú§âsheet1ªºL5~P5²¾¨ìsheet2´N¤£¦æ¤F?

TOP

§Úª¾¹D¤F,À³¸Ó­n³o¼Ë
=SUMPRODUCT((INDEX(Rng,,1)=$N$5)*(INDEX(Rng,,2)=$L$5)*(INDEX(Rng,,3)=$O$6)*(INDEX(Rng,,4)=$M$5)*(INDEX(Rng,,MATCH(N7,Sheet1!2:2,0))))

¦ý¬O½Ð°Ý³Ì«á³o­Ó"2:2"¬O¤°»ò?

TOP

¦^´_ 4# VANESSA


MATCH(N7,Sheet1!2:2,0)

¦b²Ä2¦C¤¤´M§äN7ªº¤º®e,§ä¨ì«á¶Ç¦^¨ä¦ì©ó²Ä´XÄæ

TOP

ÁÙ¦³¥L¤£·|§â¬Û¦P±ø¥óªº¼Æ¦r¥[Á`,½Ð°ÝÀ³¸Ó¦p¦ó­×§ï?
Book3.zip (10.01 KB)

TOP

¦^´_ 6# VANESSA
Book3.rar (9.51 KB)
¥u·Q¨ì¥Î6­ÓÄæ¦ì©w¸q¬Û¥[
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# VANESSA

¦³3­Ó©w¸q
Book3.rar (7.95 KB)

TOP

¦¨¥\¤F,ÁÂÁÂ2¦ì

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD