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

¦p¦óÅý¸ê®Æ®Ú¾Ú¬Y¤ë¥÷¦Ó¦Û°ÊÅã¥Ü¨äÁ`¦X¡H

¦p¦óÅý¸ê®Æ®Ú¾Ú¬Y¤ë¥÷¦Ó¦Û°ÊÅã¥Ü¨äÁ`¦X¡H

¥»©«³Ì«á¥Ñ ckinwing ©ó 2011-3-26 16:55 ½s¿è

§Ú·Q¦b²Ä¤T­Ó¤À­¶ ¡i¦Ñ®v¸ê®Æ¡j ªº C2:M8 ¦Û°ÊÅã¥Ü®Ú¾Ú¸Ó¦Ñ®v¦b¬ÛÃö¤ë¥÷©Ò¦¬¨ìªº¸É²ß¶OÁ`©M¡A
¨Ò¦p»¡¡GA¦Ñ®v¦b¤@¤ë¥÷¦¬¨ì 200 ¤¸¡FB¦Ñ®v¦b¤@¤ë¥÷¦¬¨ì 80 ¤¸ ¡]¤§«e¼g¿ù¤F¡A¤w­×§ï¡^

§Ú¹Á¸Õ¤F
SUMIFS(¦¬¾Ú¤@Äý!$G$2:$G$1001,¦¬¾Ú¤@Äý!$C$2:$C$1001,$B2,¦¬¾Ú¤@Äý!$F$2:$F$1001,column(A$1))
¥i¬O¥¢±Ñ¡C
¤]¹Á¸Õ¤F
SUMIFS(¦¬¾Ú¤@Äý!$G$2:$G$1001,¦¬¾Ú¤@Äý!$C$2:$C$1001,$B2,¦¬¾Ú¤@Äý!$F$2:$F$1001,>40543,¦¬¾Ú¤@Äý!$F$2:$F$1001,<40573)
ÁÙ¬O¥¢±Ñ¡C
©Ò¥H¤S¨Ó¨D±Ï°Õ~~
·P¿E¤£ºÉ~

¤¤¾Ç new - Copy.rar (11.89 KB)

C2=SUMIFS(¦¬¾Ú¤@Äý!$F$1:$F$21,¦¬¾Ú¤@Äý!$C$1:$C$21,¦Ñ®v¸ê®Æ!$B2,¦¬¾Ú¤@Äý!$D$1:$D$21,COLUMN(A$1))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ª©¥D¤£¦n·N«ä¡A
§Úªº­n¨D¬O®Ú¾Ú¡i¥I´Ú¤é´Á¡j¨DÁ`¦X¡A
¤ñ¦p»¡¬Y¾Ç¥Í¦b¤G¤ë¥÷ªº®É­Ô¤~ú¥I¤@¤ë¥÷ªº¸É²ß¶O¡A
¨º»ò¦Ñ®v´N¥u¯à¦b¤G¤ë¥÷¦¬¨ì¤@¤ë¥÷ªº¬ÛÃö¸É²ß¶O¡C

TOP

°Ú©Ò¥H§Úµo°ÝªºÃD¥Ø¦³°ÝÃD¡A¤£¦n·N«ä~~~
À³¸Ó¬O»¡
A¦Ñ®v¦b¤@¤ë¥÷¦¬¨ì 200 ¤¸¡FB¦Ñ®v¦b¤@¤ë¥÷¦¬¨ì 80 ¤¸ ¤~¹ï¡C

TOP

C1=SUMPRODUCT((¦¬¾Ú¤@Äý!$F$2:$F$21)*(¦¬¾Ú¤@Äý!$C$2:$C$21=¦Ñ®v¸ê®Æ!$B2)*(MONTH(¦¬¾Ú¤@Äý!$E$2:$E$21)=COLUMN(A$1)))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

½Ð±Ð==¨º­Ó¥´¤Ä¬O¦p¦ó°µªº

TOP

¦^´_ 6# p0078


    ¦r«¬
Wingdings 2
¹ê»Ú¦r¤¸¬°P
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

°ÝÃD¸Ñ¨M¤F~ ÁÂÁª©¥D¡I
¦n¨ØªA§A®@~ ¨þ¨þ~~~

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD