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

¥H¶g¼Æ¬°¤À§O¡A¸ê®Æ¥[Á`

¥H¶g¼Æ¬°¤À§O¡A¸ê®Æ¥[Á`

¦U¦ì¤j¤j§A¦n
§Ú¦³¤@±iÁ`ªí¡A¬O¨C­Ó¤ëªº¥X¶Ô¡A¦]¦³¤T­Ó¯Z§O¡A©Ò¥H­n·J¾ã¨ì¤@Á`ªí¡A¥H§Q°µ¹Ïªí
¨ä¤¤¶g¼Æªº³¡¤À¤w¥Î¤½¦¡±a¥X¨Ó¤F¡A¦p¦ó¦bÁ`ªí¥i¥H¥H¶g¤À§O¡A¸ê®Æ­pºâ¡H
data¬°¤T¯Z·J¾ãªº¸ê®Æ
Month·Q¥H¶g§Oªº¸ê®Æªí°µ­pºâ

Àµ±¡¦U¦ì°ª¤âÀ°¦£~~
thanks.



Absent(Prod.)May.rar (191.86 KB)

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-6-30 00:05 ½s¿è

C3=SUMPRODUCT((data!$C$3:$AG$3=--Month!C$2)*(OFFSET(data!$C$1,MATCH(Month!$B3,data!$B:$B,0)-1,,,31)&0)/10)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥i§_½Ð¤j¤j¸ÑÄÀ»¡©ú¤@¤U
¤£¤Ó¤F¸Ñ³o¨â­Ó»yªkªº¨Ï¥Î
Thanks.

TOP

¬°¦ó§Ú½Æ»sC3-->E3 ¼Æ­È«o»P¹ê»Ú¤Wªº¥[Á`¼Æ¦r¤£²Å¡H@@

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-6-30 00:36 ½s¿è

¦^´_ 4# vickyl

¦]¬°§AªºData¤º®eªÅ¥Õ³B¬O""¡A­ì¥»¥Î&0/10ªº¤è¦¡¥u¯à¾A¦X¾ã¼Æ
¦]¬°¤p¼ÆÂIªº°ÝÃD³y¦¨°£¥H10ªº®t¿ù¡A¨º´N±o¦A·Q¨ä¥L¿ìªk
C3°}¦C¤½¦¡
=SUMPRODUCT((data!$C$3:$AG$3=--Month!C$2)*IF(OFFSET(data!$C$1,MATCH(Month!$B3,data!$B:$B,0)-1,,,31)="",0,OFFSET(data!$C$1,MATCH(Month!$B3,data!$B:$B,0)-1,,,31)))
©Î¬O§Aªº¤½¦¡­Y­n¶Ç¦^""ªº³¡¤À³£§ï¦¨¶Ç¦^0¡A(­Y¤£·QÅã¥Ü0´N¦bÀ˵ø³]©w¤¤³]©w¤£Åã¥Ü¹s­È)
¤~¯à°÷¨Ï¥ÎSUMPRODUCT¨Ó­pºâ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# Hsieh


    ÁÂÁ¤j¤jªº¸Ñµª¡I
©Ò¥H¥Ø«e¼Æ­È¤£¯à¦³¤p¼ÆÂI¡A´N¥i¥H¤F¡I

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD