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

[µo°Ý] ½Ð°Ý1Äæ*1¦C¦A¨Cµ§¥[Á` ¤ñ¼ÆÃe¤j¦p¦ó¥Î¤½¦¡¥[Á`

[µo°Ý] ½Ð°Ý1Äæ*1¦C¦A¨Cµ§¥[Á` ¤ñ¼ÆÃe¤j¦p¦ó¥Î¤½¦¡¥[Á`

¦p¹Ï¤ù¡A³o­Ó¤½¦¡´N¬O±q(C2~C123*P126~EG126) ¤@­ÓÄæ¦ì*¤@¦C¦A¥þ³¡¥[Á`


§Ú·Q¨ìªº¬O¥ÎSUMPRODUCT¡A¦ý¬O­n¨âÃ䪺­È³£¬O¾îªº¤~¦³¿ìªk¹F¦¨
­n³Ò·Ðª©¤Wªº¤j¤jÀ°¦£½T»{¬O§_¦³¨ç¼Æ¥i¥H¹F¦¨³o­Óºâ¦¡
·PÁÂ!!


TEST.rar (72.6 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2016-6-7 10:05 ½s¿è

¦^´_ 1# abc9gad2016
Àx¦s®æC126¿é¤J°}¦C¤½¦¡ (Ctrl+Shift+Enter¤TÁä»ô«ö¿é¤J)
=ROUNDUP(SUM(TRANSPOSE(C$2:C$123)*$P126:$EG126),0)
¦V¤U¦V¥k½Æ»s
½Ð°Ñ¦Ò¡I

TOP

{=ROUND(SUM(TRANSPOSE(C2:C123)*P126:EG126),0)

TOP

¦^´_ 2# p212


·PÁ¤j¤j¡A§Ú«á¨Ó¦Û¤v§ä¨ìªº¤èªk¤]¬O¥ÎTRANSPOSE¥h±N¤é´Á¤]§ï¦¨¾î¦¡¡A¦b¬Û­¼¥[

¦ý§Ú¬O¥ÎSUMPRODUCT¥h­pºâ¡A«ç»ò¸òSUM­pºâªºÅÞ¿è¬O¤@¼Ëªº!!Åå³Y

TOP

¤£¦n·N«ä¥t¥~¦A½Ð°Ý«e½ú¡A­YAÄæ¦WºÙ¸ò124.125¦C¦³·sªº¥N¸¹­n·s¼W(´¡¤J·sªº¦C¸òÄæ)
¨º¤½¦¡¦³¿ìªk¦Û¤v¼W¥[¶Ü?ÁÙ¬O»Ý­n¦A­«·s©Ô¤@¹M ·PÁÂ

TOP

¦^´_ 5# abc9gad2016

=ROUNDUP(SUM(TRANSPOSE(C$2:C$123)*$P126:$EG126),0)
´¡¤J¦b$2:$123¤ÎP:EG½d³ò¤º®É¤½¦¡·|¦Û°Ê­×§ï¡A¥H¥~¤£·|

¨Ò¦p´¡¤J122¦C¦b±N«á­±ªº¦C¸ê®Æ©¹«e½Æ»s´N¥i
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ML089

ÁÂÁ«e½ú!!

TOP

¦^´_ 6# ML089

¤£¦n·N«ä¡A·Q¦A½Ð±Ð¤@¤U«e½ú
¬°¤°»ò³oÃä¥i¥H¥ÎSUM¡C§Ú¬O¥ÎSUMPRODUCT¥h§¹¦¨­pºâ
§Ú«á¨Ó²³æ¸Õ¤F³o¨â­Ó¨ç¼Æ¡A¤@¼Ëªº­È¡Aµ²ªG¥X¨Ó¬O¤£¦Pªº

TOP

¦^´_ 8# abc9gad2016

=ROUNDUP(SUM(TRANSPOSE(C$2:C$123)*$P126:$EG126),0)
»P
=ROUNDUP(SUMPRODUCT(TRANSPOSE(C$2:C$123)*$P126:$EG126),0)

³£»Ý­n¨Ï¥Î ¤TÁä¿é¤J CTRL+SHIFT+ENTER

¦]¬°TRANSPOSE¨ç¼Æ»Ý­n¨Ï¥Î¤TÁä¿é¤J
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD