ªð¦^¦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¡^



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

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

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

·PÁÂhcm19522¦^ÂСA§Aªººâªk¦b®É¶¡¤À°t¤W¸ò§Úªºªí¹F·N«ä¤£¦P

¥HB2¡GF2
¥Í²£¼Æ¶q 6 ¡B8¡B2¡B4 ¡A¨Ï¥Î®É¶¡¬O Á`¦@50¤À¡A¤£¬O¦U¦Û 50¤À

¹Ï¤ù 001.jpg
¥Î§Aªº­pºâµ²ªG¦^±À
6A + 8B + 2C + 4D ¡× 178.324 ¡A¤£¬O 50
¡ãºµ¿ß¬É²Ä¤@¬ü¨k¤l¡ã

TOP

¸É¥R¡G¦]¬°¬Oºâ¥­§¡­È
§Ú¥Î­pºâµ²ªG¦^±À 6A + 8B + 2C + 4D ¡× 178.324 ¦n¹³¤]¤£¹ï
¡ãºµ¿ß¬É²Ä¤@¬ü¨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"))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

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

¡ãºµ¿ß¬É²Ä¤@¬ü¨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ª«¥óÁ`®É¶¡¼Æ
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 7# hcm19522

ÁÂÁÂ

§Ú¥ý®M¥Î¦bªí®æ¤W¡A²Ö¿n¸ê®ÆÆ[¹î¬Ý¬Ý
¡ãºµ¿ß¬É²Ä¤@¬ü¨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

¦^´_ 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

¡ãºµ¿ß¬É²Ä¤@¬ü¨k¤l¡ã

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD