hcm19522

http://www.FunP.Net/186097

jeff5424

¦^´_ 7# hcm19522
hcm195222¤j¤j,¥i¯à§Ú¤ñ¸û²Â,¸Õ¤£¥X¨Ó,¥i¥H³Â·Ð¤j¤jÀ°§Ú§ï­ì©lÀɶÜ?

hcm19522

¤è¦¡¤G :µ{¦¡«á­±ROW(A1)-->MOD(ROW(A1),4) ª½±µ©Ô¨ì¦ì
F5=SUM(F2:F4) ,¥ª©Ô¨ìO5 ,F5¤À§O½Æ»s¨ìF9 ,F13 ,¤À§O¥ª©Ô¨ìO9 ,O13 (ª©¤j®æ¦¡SUM³¡¤À¤@¤@½Æ»s ©¹¥k©Ô)
¥H3#¬°¨Ò
3#¦³­×§ï¼W¦C

hcm19522

SUMPRODUCT(($A$2:$A$5000=LOOKUP(1,0/($D$2:$D2<>""),$D$2:$D2))*(INT($B$2:$B$5000)=F$1)*(LOOKUP(MOD($B$2:$B$5000,1),--MID($E$2:$E$4,3,5),ROW($1:$3))=ROW(A1)))
ROW(1:3)-->ROW($1:$3)

jeff5424

¦^´_ 3# hcm19522
hcm19522¤j¤j§Ú´ú¸ÕÁÙ¦³°ÝÃD,¦b³Â·Ð¤j¤j¦AÀ°§Ú¬Ý¬Ý.....ÁÂÁÂ
¦pªþ¥ó©Ò¥Ü

jeff5424

·PÁÂhcm19522¤j¤jªºÀ°¦£.....ÁÂÁÂ

hcm19522

http://blog.xuite.net/hcm19522/twblog/360767792
°Ñ¦Ò

hcm19522

=SUMPRODUCT((LOOKUP(1,0/($A$4:$A4<>""),$A$4:$A4)=summary!$D$3:$D$5000)*(INT(summary!$F$3:$F$5000)=D$2)*(LOOKUP(MOD(summary!$F$3:$F$5000,1),--MID($B$4:$B$6,3,5),ROW($1:$3))=ROW(B1)))