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

¤é²£¯à´«ºâ¦¨¶g²£¯à

¤é²£¯à´«ºâ¦¨¶g²£¯à

½Ð±Ð, ¯à§_§iª¾¦p¦óÂà´«¦b¥t¤@Excel Àɮפ§¤é²£¯à(¤w¨Ì¤é´Á±Æ¦C¦n),¶g¥[Á`§e²{¦b¥t¤@­ÓExcel ÀÉ, ¥H¶g¦¸§e²{? ÁÂÁÂ
¬O±Ä¥Î¨ç¼ÆSumproduct¶Ü? ¦p¦ó³]©w?

¦^´_ 1# eunice_chuang
¥i§_¶Ç­Ó½d¨ÒÀÉ(§t¸ê®Æ¨Ó·½»P´Á«Ýªºµ²ªG)¨Ñ°Ñ¡HÁÂÁ¡I

TOP

¦^´_ 2# p212

½Ð°Ñ¦Òªþ¥ó. »Ý±NHub ¤Îcable ©ñ¦b¤é²£¯àExcel sheet ¸ê®Æ, ¨Ì¶g¦¸ºâ¥XÁ`©M, ¦^¶ñ¨ì"Summary" ¤£¦P¶g¦¸¤¤. ¸Õ¤F´X¦¸, µLªk§ä¨ì¥¿½T¨ç¼Æ³]©w. ·Ð½ÐÀ°¦£Åo!

Excel_Âà´«½m²ß.zip (7.47 KB)

TOP

¦^´_ 3# eunice_chuang


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh

¥i§_´£¨ÑÀÉ®×? ¹Ï¤ùµLªk½Æ¨î. ÁÂÁÂ.

TOP

¦^´_ 5# eunice_chuang


    B3
=SUMPRODUCT(((INT((¤é²£¯à!$B$2:$U$2-"2013/1/1")/7)+1)=COLUMN(A$1))*(¤é²£¯à!$B4:$U4))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¹ï¤£°_, ¦³ÂI°ÝÃD. ®M¤J¨ç¼Æºâ¥X¨Óªº­È¤£¥¿½T. ¥i§_¦AÀ°¦£¬Ý¬Ý.

¥t¥~, ¥i§_¦A½Ð±Ð, ­Y¬OSummary §ï¦¨¥H¨C¶g¤@¤§¤é´Á¨ú¥NwkXX, ¥i§_°µ?  ÁÂÁÂ

³Â·Ð¤F.

Excel_Âà´«½m²ß_new.zip (8.77 KB)

TOP

¦^´_ 7# eunice_chuang
©P§Oªº­pºâ¥²¶·»P©Pªº°_ºâ¤é³W«h°t¦X
¥HWEEKNUM¨ç¼Æ­pºâ¨t²Î¹w³]±q1/1°_ºâ¬°²Ä¤@©P¡A¤@©Pªº°_©l¤é¬°¬P´Á¤@
©Ò¥H¡A°Ñ¦Ò¤U¹Ï¡A¦PÃC¦â¬°¦P¤@©Pªº¸ê®Æ


«hB3¤½¦¡¬°=SUMPRODUCT((WEEKNUM(¤é²£¯à!$B$2:$U$2*10^0)=WEEKNUM(Summary_new!B$2))*(¤é²£¯à!$B4:$U4))
¦p¤U¹Ï
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥[¤J£¸­Ó©P§OÄæ¡A¸Õ¥Î¼Ï¯Ã¤ÀªR°µ

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD