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

[µo°Ý]±ø¥ó¥[Á`

[µo°Ý]±ø¥ó¥[Á`

¥»©«³Ì«á¥Ñ oui ©ó 2010-11-26 15:00 ½s¿è

¦U¦ì¤j¤j­Ì¡A
¦³¤T¶¥¬qAA, AB, AC»P¤TºØÃþ§OA1, A2, B
A1¥]§tAA»PAC¶¥¬q
A2¥]§tAA, AB,»PAC¶¥¬q
B¥]§tAA¶¥¬q
AA, AB,AC©Ò§t¬Aªº¤é´Á±µ¤£¬Û¦P¡A¦pªþ¥óªºÄæ¦ìC:F©Ò¥Ü¡C
­YÄæ¦ìC:F¬Ò¬°ªÅ¥Õ¡A«h¥HÃþ§O¬°§PÂ_¡A¦p¤U¡G
A2¬°AB¶¥¬q
B¬°AA¶¥¬q

µM«á§Ú§Æ±æ¨Ì¾Ú¤£¦Pªº¤ë¥÷°µ¶¥¬qªº¥[Á`¡C
§Ú²{¦bªº¤è¦¡¬O¥ý±N¨C­Ó¤ë¥÷©ÒÄݪºÄæ¦ì¥ý§PÂ_¬OÄݩ󨺭Ӷ¥¬q¡AµM«á¦b¥Îsumif¥[Á`¡C

¥i¬O§Úı±o³oÀ³¸Ó¥i¥H¥Î¡u¯x°}¡vªº¤è¦¡¡A½Ð°Ý¦U¦ì¤j¤j¸Ó¦p¦ó°µ©O¡HÁÙ¬O¦³§ó²«Kªº¤è¦¡©O¡H
100 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¥»©«³Ì«á¥Ñ oui ©ó 2010-11-26 15:09 ½s¿è

¦^´_ 1# oui

ªþ¥ó¦p¤U¡G

±ø¥ó¥[Á`.zip (3.89 KB)

100 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 2# oui

¤W¶Çªº¸ê®ÆªþÀɦW¥²¶·
chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png ¤~¦æ
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

TOP

­è­èª¦§¹<Àx¦s®æ°ò¥»¥\>¡A¬ðµMª¾¹D¸Ó¦p¦ó¤U¤â¤F¡C
AA={SUM(IF(($B$4:$B$11="B")+($D$4:$D$11>=G$2),G$4:G$11,0))}
AB={=SUM(IF(($B$4:$B$11="A2")*(C$4:C$11="")+($D$4:$D$11<=G$2)*($E$4:$E$11>=G$2),G$4:G$11,0))}
AC={SUM(IF(($F$4:$F$11<>"")*($F$4:$F$11<=G$2),G$4:G$11,0)}

ªG¯u¡A¨S¨ÆÁÙ¬O­n¦hª¦®æ¤l¡A½m½m°ò¥»¥\¡C

±ø¥ó¥[Á`.zip (4.46 KB)

100 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD