SUMPRODUCT ¹J¨ìªÅ¥ÕÀx¦s®æÅã¥Ü¿ù»~¸Ñ¨M¤èªk
- ©«¤l
- 4
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 6
- ÂI¦W
- 0
- §@·~¨t²Î
- w7
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2014-11-2
- ³Ì«áµn¿ý
- 2014-12-11
|
SUMPRODUCT ¹J¨ìªÅ¥ÕÀx¦s®æÅã¥Ü¿ù»~¸Ñ¨M¤èªk
·Q½Ð±Ð =SUMPRODUCT(F18:F28*G18:G28) ¬O§Ú²{¦b³]©wªº¨ç¼Æ¡A
¦pªG§Ú§R°£¤F ¦C F28¡AG27ªº¼Æ¾Ú«á¡A¥L´N·|Åã¥Ü¿ù»~°T®§¡A³o¥i¥H«ç»ò¸Ñ¨M¶Ü¡H §Ú¬ã¨s¦n¤[.. ¤£ª¾¹D¸Ó«ç»ò³]¨ç¼Æ¡C |
|
|
|
|
|
|
- ©«¤l
- 4
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 6
- ÂI¦W
- 0
- §@·~¨t²Î
- w7
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2014-11-2
- ³Ì«áµn¿ý
- 2014-12-11
|
ÁÂÁ¤j®a!! §Ú·|¤F!!! ·PÁ |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 3# alivewmc
=SUMPRODUCT(³æ»ù1*¼Æ¶q1)
§ï¬°
=SUMPRODUCT(³æ»ù1,¼Æ¶q1)
´N¬O±N * §ï¬° , |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2014-11-4 09:59 ½s¿è
¦^´_ 3# alivewmc
´N3#ªþÀɤ¤ì¦³ªº¦WºÙ©w¸q«Øijקï¦p¤U¡G
©w¸q¦WºÙ¡u³æ»ù1¡v°Ñ·Ó¨ì
=OFFSET(pºâªí!$K$3,,,COUNT(pºâªí!$K:$K))
©w¸q¦WºÙ¡u¼Æ¶q1¡v°Ñ·Ó¨ì
=OFFSET(pºâªí!$L$3,,,COUNT(pºâªí!$L:$L))
½Ð°Ñ¦Ò¡I |
|
|
|
|
|
|
- ©«¤l
- 4
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 6
- ÂI¦W
- 0
- §@·~¨t²Î
- w7
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2014-11-2
- ³Ì«áµn¿ý
- 2014-12-11
|
¦^´_ 2# luhpro
§Ú¸ÕµÛ©w¸q¦WºÙ«ápºâ¡A¦ý¤´¬O¿ù»~°T®§...
´ú¸Õª© (1).rar (10.62 KB)
¦³°ª¤â¥i¥HÀ°§U§Ú¶Ü.. ÁÂÁ |
|
|
|
|
|
|
- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 16
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-11-14
|
·Q½Ð±Ð =SUMPRODUCT(F18:F28*G18:G28) ¬O§Ú²{¦b³]©wªº¨ç¼Æ¡A
¦pªG§Ú§R°£¤F ¦C F28¡AG27ªº¼Æ¾Ú«á¡A¥L´N ...
alivewmc µoªí©ó 2014-11-2 16:51
¤@¯ë³B²z§R°£Àx¦s®æ¾ÉPµo¥Í¤½¦¡¿ù»~°T®§ªº¤è¦¡,
¬O±N³B²z½d³ò©w¸q¦WºÙ,
¤½¦¡¸Ì«h¹ï¦WºÙ°µ¬ÛÃöpºâ. |
|
|
|
|
|
|