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

¦p¦ó¦Û°Ê²Î­p©Ê§O¦~ÄÖ¼h¤H¼Æ?

¦p¦ó¦Û°Ê²Î­p©Ê§O¦~ÄÖ¼h¤H¼Æ?

©Ê§O¦~ÄÖ¼h²Î­pªí.rar (9.14 KB)
¦b¤@¥÷¦W¥U¤¤¦p¦ó¦Û°Ê­pºâ©Ê§O¤Î¦U¦~ÄÖ¼h¤H­û­Ó¼Æ¡A¤p§Ì·Q¯}¸£³U·Q¤£¥X¨Ó¡A½Ð±Ð¦U¦ì¢Ó¢æ¢Ñ¢Ó¢Ú¥ý¶i¦³¦óºØ¨ç¼Æ¥i¸Ñ¨M¡AÁÂÁ¡C

¦^´_ 1# wenwu748

K3=SUMPRODUCT(($B$2:$B$16=$J3)*($A$2:$A$16=$I3)*($D$2:$D$16=K$2)*(LOOKUP(INT((TEXT(TODAY(),"e")-$E$2:$E$16+1)/10),{0,2,3,4,5,6,7,8,9})=INT((COLUMN(A1)+3)/2)))
¦V¥k¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁ¶W¯Åª©¥Dªº¦^µª
¤£¹L¦n¹³§Úªºªíµª¦³°ÝÃDJ15ªº¾F¼Æ15¬OÂЮ֥Τ£¬O¥Î¨Ó§ä²Ä15¾Fªº©Ê§O¤Î¦~ÄÖ¼h­Ó¼Æ¡A§Ú­nªº¬O­pºâ¨½ªº©Ê§O¤Î¦U¦~ÄÖ¼h¤H­û­Ó¼Æ¡A¥i§_¦AÀ°¦£­×§ï¤@¤U¡AÁÂÁ¶W¯Åª©¥D

TOP

K3=SUMPRODUCT(($D$2:$D$16=K$2)*($E$2:$E$16>=((INT((COLUMN(A1)+1)/2)+1)*10))*($E$2:$E$16<(((INT((COLUMN(C1)+1)/2))+1)*10))*1)

TOP

ÁÂÁÂANGELAª©¥Dªº¸Ñµª¨ü¥ÎµL½a

TOP

³Ìªñ¤]¸I¨ì³o¼ËªºÃøÃD¡A¤£¹L²Î­pªºªF¦è¤£¦P¡A§Ú·QÀ³¸Ó¤è¦¡¬O¤@¼Ëªº¡C

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD