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

[½Ð°Ý] ­pºâ¥­§¡®É¶¡

[½Ð°Ý] ­pºâ¥­§¡®É¶¡

¥»©«³Ì«á¥Ñ luckeyfly ©ó 2019-1-10 14:14 ½s¿è

½d¨Ò¹Ï¤ùªº¼Æ¦r¬O¶Ã¼Æ²£¥Í

°ÝÃD¥»¨­À³¸Ó¬O¥|¤¸¤@¦¸ªº¨D¸Ñ

¤H­û-¤ý¡G6A + 8B + 2C +4D = 50
¤H­û-§õ¡G1A + 1B + 5C + 1D ¡× 31
..
...
²M³æ¬O«ö¤é²Ö¿nªº¡A·|«ùÄò¼W¥[

¨D¸Ñ
¤H­û-¤ýªºA¡BB¡BC¡BD ¤À§O¬O¦h¤Ö¡]B21¡GE21ªº¤½¦¡¼gªk¡^
¤H­û-§õªºA¡BB¡BC¡BD ¤À§O¬O¦h¤Ö¡]B22¡GE22ªº¤½¦¡¼gªk¡^

¹Ï¤ù 004.jpg
2019-1-10 14:09


ASK-4.rar (8.42 KB)
¡ãºµ¿ß¬É²Ä¤@¬ü¨k¤l¡ã

¦^´_ 12# luckeyfly

¤Þ¦ù§Aªº·§©À¡A¨C¥|²Õ¼Æ¾Ú¥Î¥|¤¸¤@¦¸¨D¥X°ß¤@¸Ñ¡AµM«á¦A§â°ß¤@¸Ñ²Ö¿n¤U¥h°µ¥­§¡­È
¦ý¬O³o¼Ë·|Åܦ¨¸ê®Æ¤@©w­n¥|²Õ¬°¤@­Ó³æ¦ì
¹ê»Ú¤W¤£¥i¯à¨C­Ó¤ëªº¤u§@¶q³£¯à­è­è¦n¤À°tµ¹¨C­Ó­û¤u³£®³¨ì4ªº­¿¼Æ¡A¨C­Ó­û¤u³£¦³¥i¯à¦³1¡ã3²Õ¸ê®ÆµLªk­pºâ¨D¸Ñ


--------------------------------------

¤£¥Î­è¦n¬O4ªº­¿¼Æ

²Ä1²Õ  ¸ê®Æ1~4
²Ä2²Õ  ¸ê®Æ2~5
²Ä3²Õ  ¸ê®Æ3~6
...

¥u­n¤j©ó4²Õ¸ê®Æ¡A´N¥i¥H³v¦¸¤U²¾¨D±o¦h¦¸¸Ñ«á¡A¦b±N¨C¤@¶µ¨D³Ì¤j¡B³Ì¤p¡B¼Ð·Ç®t....µ¥
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ luckeyfly ©ó 2019-1-15 08:20 ½s¿è
¥Î4¤¸¤@¦¸¤èµ{¦¡¸Ñ¡AÁöµM«Y¼Æ±a¦^«áµª®×²Å¦X¡A¦ýÀ³¸Ó¤£¬O§A±o­nªºµª®×¡A¥i¯à¬O§Aªº¸ê®Æ«Y¼Æ¥Î¶Ã¼Æ²£¥Í¡A ...
ML089 µoªí©ó 2019-1-14 15:24


¦]¬°¥|¤¸¤@¦¸¬O¨D¡u°ß¤@¸Ñ¡v¡A¸ê®Æ¿ù»~·|¾É­Pµª®×¿ù»~

¶Ã¼Æ²£¥Íªº¸ê®Æ¡A¥i¥H¬Ý¦¨¨C¤Ñª¬ªp¤£¦P¾É­Pªº¥Í²£®Ä²v¤£¦P¡A·|¼vÅT¨D¨ú¥|¤¸¤@¦¸ªº°ß¤@¸Ñ¡A¦ý¬O¸ê®Æ·|ÀHµÛ¤u§@¶i«×¤£Â_¼W¥[²Ö¿n¦b¥­§¡­È­pºâ¤W³»¦h´N¬O©Ô°ª©Î­°§C¥­§¡­È¦Ó¤w

²Ö¿n§ä¥X¥­§¡­È¤§«á¡A¹ï©ó¥Í²£½Õ«×¤~¯à¦³¤ñ¸û·Ç½Tªº¹w¦ô




¤Þ¦ù§Aªº·§©À¡A¨C¥|²Õ¼Æ¾Ú¥Î¥|¤¸¤@¦¸¨D¥X°ß¤@¸Ñ¡AµM«á¦A§â°ß¤@¸Ñ²Ö¿n¤U¥h°µ¥­§¡­È

¦ý¬O³o¼Ë·|Åܦ¨¸ê®Æ¤@©w­n¥|²Õ¬°¤@­Ó³æ¦ì

¹ê»Ú¤W¤£¥i¯à¨C­Ó¤ëªº¤u§@¶q³£¯à­è­è¦n¤À°tµ¹¨C­Ó­û¤u³£®³¨ì4ªº­¿¼Æ¡A¨C­Ó­û¤u³£¦³¥i¯à¦³1¡ã3²Õ¸ê®ÆµLªk­pºâ¨D¸Ñ

¡]¦pªG¥Í²£ª«¥ó¬O5ºØ¡B7ºØ¬Æ¦Ü§ó¦h¡AµLªk­pºâ¨D¸Ñªº¿òº|¸ê®Æ·|§ó¦h¡^
¡ãºµ¿ß¬É²Ä¤@¬ü¨k¤l¡ã

TOP

ASK-4.rar (8.13 KB)

¥Î4¤¸¤@¦¸¤èµ{¦¡¸Ñ¡AÁöµM«Y¼Æ±a¦^«áµª®×²Å¦X¡A¦ýÀ³¸Ó¤£¬O§A±o­nªºµª®×¡A¥i¯à¬O§Aªº¸ê®Æ«Y¼Æ¥Î¶Ã¼Æ²£¥Í¡A¨Ã«D¹ê»Úª¬ªp¡A©Ò¥Hµª®×«D¹ê»Ú»Ý¨D¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# ­ã´£³¡ªL

·PÁ¦^ÂÐ

­ã¤jªº¤½¦¡ºâ¥X¨Ó¼Æ­È¹L¤j¡]Ãþ¦ühcm19522¤j¤jªº²Ä¤G¦¸¤½¦¡¡^

¤ý ªº 1A + 1B +1C + 1D ¦X­p¥­§¡®É¶¡ 388 ¡A»·¶W¹L¥ªÃ䪺®É¶¡FÄæ¡A¬Æ¦Ü³æ1A¥­§¡®É¶¡´N¶W¹LFÄæ¤F
   
¦pªG¤£°Ï¤ÀA¡BB¡BC¡BD¡Aª½±µ¥ÎÁ`®É¶¡/Á`¼Æ¶qºâ¡A³æ­Ó¥­§¡®É¶¡ªº°Ñ¦Ò­È¤j¬ù¸¨¦b 2.5 - 2.7

¹Ï¤ù 003.jpg
2019-1-14 08:18
¡ãºµ¿ß¬É²Ä¤@¬ü¨k¤l¡ã

TOP

±N²Î­p²¾¦ÜH~MÄæ
Xl0000365.rar (4.27 KB)

I3/¤½¦¡: ¥k©Ô¤U©Ô
=SUMIF($A:$A,$H3,$F:$F)*SUMIF($A:$A,$H3,B:B)/SUM(SUMIF($A:$A,$H3,OFFSET($A:$A,,{1,2,3,4})))

TOP

¦^´_ 7# hcm19522

ÁÂÁÂ

§Ú¥ý®M¥Î¦bªí®æ¤W¡A²Ö¿n¸ê®ÆÆ[¹î¬Ý¬Ý
¡ãºµ¿ß¬É²Ä¤@¬ü¨k¤l¡ã

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2019-1-11 14:36 ½s¿è

I3:L4=SUMPRODUCT(($A$2:$A$99=$H3)*B$2:B$99*$F$2:$F$99/TEXT(MMULT((0&$B$2:$E$99)*1,{1;1;1;1}),"0;;1"))/SUMIF($A$2:$A$99,$H3,B$2:B$99)
«á­±¦Uª«¥óÁ`¼Æ  «e­±¦Uª«¥óÁ`®É¶¡¼Æ
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 5# hcm19522

FÄæ¦ì¬O¦h­Óª««~ªº¥Í²£®É¶¡¬Û¥[¡AB¡GFªº·N¸q¬O¤@µ§­q³æªº¥Í²£¶µ¥Ø¼Æ¶q©M¥Í²£ªá¶O®É¶¡¡AA¬O°õ¦æªÌ
¦pªG¤À©î¤U¨Óªº³æ­Ó¥­§¡®É¶¡¤j©óFÄæ´N¤£¦X²z¤F¡AÀ³¸Ó¬O»·»·¤p©óFÄæ

¤j¤jªº·s¤½¦¡¡A¶K¤W«á­pºâªº¼Æ­È³£¦b90UP¡A©úÅ㤣¦XÅÞ¿è

¦pªG¤£°Ï¤ÀA¡BB¡BC¡BD¡Aª½±µ¥ÎÁ`¼Æ¶qºâ¡A³æ­Ó¥­§¡®É¶¡ªº°Ñ¦Ò­È¤j¬ù¸¨¦b 2.5 - 2.7

¹Ï¤ù 001.jpg
2019-1-11 13:28
¡ãºµ¿ß¬É²Ä¤@¬ü¨k¤l¡ã

TOP

¦^´_ 4# luckeyfly

I3:L4=SUMPRODUCT(($A$2:$A$99=$H3)*B$2:B$99*$F$2:$F$99/TEXT(MMULT((0&$B$2:$E$99)*1,{1;1;1;1}),"0;;1"))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD