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

SUMPRODUCT

SUMPRODUCT

·|¨Ï¥Î¨ç¼ÆSUMPRODUCT,½ÐÀ°§Ú¬Ý¤@¤U¬°¦ósheet "Shipping Statistics (only HK)"¤½¦¡²Ä6¤Î²Ä10¦CµLªk¥[Á`?
SUMPRODUCT.zip (143.55 KB)

¦^´_ 1# PJChen

D6=ROUND(SUMPRODUCT(('Factory Ship'!$AD$4:$AD$3124=D$1)*('Factory Ship'!$AU$4:$AU$3124=$F$4)*('Factory Ship'!$AE$4:$AE$3124))/7.8,2)
D10=SUMPRODUCT(('Factory Ship'!$AD$4:$AD$3124=D$1)*('Factory Ship'!$AU$4:$AU$3124=$F$4)*('Factory Ship'!$AS$4:$AS$3124))
Factory Ship¤u§@ªí¤§ASÄ榳¤£¥i¨£¦r¤¸

SUMPRODUCT.rar (64.01 KB)

TOP

¦^´_ 2# register313

½Ð°Ý,:
1) ¦C¸¹6:§Ú¥Î¦Û¤v­ì¨Óªº¼Ð®×¥h´ú¸Õ¬°¦óÁÙ¬OµLªk¥[Á`?±z¨Ã¥¼­×§ï¤½¦¡,¬°¦ó¤S¥i¥H¥[Á`©O?
2) ¦C¸¹10:§Ú­n¦p¦óÀˬd¬Ý¤£¨£¦r¤¸?

TOP

¦^´_ 3# PJChen

1.D6»PD10¤§¤½¦¡¬Ò¦³­×§ï  =>  ¬A¸¹¦³­×§ï
2.³Ì²³æ¤§¤èªk
  ½Æ»sAS1~AS421Àx¦s®æ ¨ì WORD §Yª¾

TOP

¦^´_ 4# register313

¥i¦æ¤F!ÁÂÁÂ.

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD