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

[µo°Ý] «öªÀ­ûµf¸¹²Î­p¨C¤ë¶Ô«å¦¸¼Æ

[µo°Ý] «öªÀ­ûµf¸¹²Î­p¨C¤ë¶Ô«å¦¸¼Æ

late.rar (49.42 KB) ¥i§_«öªÀ­ûµf¸¹, ±qSHEET "DATA"¤º¤£¦Pªº¤í¶ÔÃþ§O, «ö¤£¦P¤é´Á®É¬q©ñ©ó"SUMMARY"ªí? ¥ÎSUMPRODUCT¦ý­n­ÝÅUªº¤ë¥÷¤Ó¦h, ¦ý¤£¥i¥ÎVBA, ½Ð½ç±Ð

§Adata¤u§@ªíªº¤é´Á¬O2013¡Asummary¤u§@ªíªº¤é´Á¬O2014¡B2015¡A¤ñ¹ï¤U¨Ó¡A¨S¦³²Å¦Xªº­È°Ú

TOP

late (V2).rar (49.37 KB) ¦^´_ 2# ¹q·xÄl

:( ¯u©êºp! ²{¸É¦^¥¿½TÀÉ. §Ú¥ÎSUMPRODUCT, ¦ý¹B§@«ÜºC, ¥¼ª¾¦³¨S¦³¨ä¥L²³æ¤@ÂIªº¤u¦¡? ¦]¬°¨ì®É¬O­n°µ130¤Hªº¼Æ¾Ú, ´N·|¹B§@§óºC¤F.....:'(

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-2-3 10:17 ½s¿è

¦^´_ 3# missbb
data¤u§@ªí¥H¡u©w¸q¦WºÙ¡v»s§@¡u°ÊºA½d³ò¡v¡A¸Ó¦³®Ä½d³òÀ³¥i¥[³tSUMPRODUCT¹Bºâ¡C
SUMMARY¤u§@ªí¤§Àx¦s®æC4¿é¤J¤½¦¡
=SUMPRODUCT((Employee=$A4)*(¤í¶ÔÃþ§O=$B4)*(Date>=C$2)*(Date<=C$3))
¦V¥k¡B¦V¤U½Æ»s
½Ð°Ñ¨£ªþ¥ó¡I

late_ref.zip (49.06 KB)

TOP

¦^´_ 3# missbb
  1. =COUNTIFS(data!$A:$A,SUMMARY!$A4,data!$L:$L,SUMMARY!$B4,data!$I:$I,">="&SUMMARY!C$2,data!$I:$I,"<="&SUMMARY!C$3)
½Æ»s¥N½X
¥ÎCOUNTIFS¬Ý·|¤£·|§ÖÂI
late (V2)-countifs.rar (50.52 KB)

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD