½Ð°Ý¥H¤U¤½¦¡¦p¦ó¼g??

cheukyiu19

A
1¡@¡@¡@¡@¢±1
2¡@¡@¡@¡@15
3¡@¡@¡@¡@¢±1
4¡@¡@¡@¡@11
5¡@¡@¡@¡@9
6¡@¡@¡@¡@8
7¡@¡@¡@¡@18
8¡@¡@¡@¡@5
9¡@¡@¡@¡@9
10¡@¡@¡@  ¢±1

  A>10 ªº¦¸¼Æ¬°6¦¸, µM«á ¦b³o6¦¸¤§¤¤ ,§Ú·Q¦A¥[¤@­Ó¤½¦¡´N¬O , count A(x-1)>A(x)   ªº¦¸¼Æ
·N«ä¬O­pºâ,A¥²»Ý¤j¹L10,µM«á¤W¤@®æÀx¦s®æªº¼Æ­È¤ñ¤U¤@®æªº¼Æ­È¤j

A>10 ¿ï¥Xªº¥u¦³ A1,A2,A3,A4,A7,A10
¥HA10§@¨Ò,A9¥²»Ý¤j¹LA10

ML089

¦^´_  Hsieh

ÁÂÁª©¥D¡A½Ð°Ý¥i§_½Ð±Ð¤@¤U sum product ªº¥Îªk¡H
cheukyiu19 µoªí©ó 2014-5-15 23:58

SUMPRODUCT ¨ç¼Æ

¶Ç¦^¦U°}¦C¤¤©Ò¦³¹ïÀ³¤¸¯À­¼¿nªºÁ`©M¡C

»yªk

SUMPRODUCT(array1,array2,array3, ...)

Array1, array2, array3, ...   ¬O 2 ¨ì 255 ­Ó±ý¨D¨ä¹ïÀ³¤¸¯À­¼¿n¤§©Mªº°}¦C¡C

³Æµù

¦U°}¦C¥²¶·¦³¬Û¦Pªººû«× (¬Û¦Pªº¦C¼Æ¡A¬Û¦PªºÄæ¼Æ)¡C§_«h SUMPRODUCT ¨ç¼Æ·|¶Ç¦^¿ù»~­È #VALUE!¡C
SUMPRODUCT ¨ç¼Æ·|±N©Ò¦³«D¼Æ­È¸ê®Æªº°}¦C¤¸¯À·í¦¨ 0 ¨Ó³B²z¡C


½d¨Ò1
A2:A9 ³æ»ù
B2:B9 ¼Æ¶q
C2:C9 ¦X­p
Á`­p =SUM(C2:C9)

°ÝÃD1: ­Y¨S¦³C2:C9¦X­pÄæ®É¡A­n¦p¦ó¨DÁ`­p
¸Ñµª1: Á`­p =SUMPRODUCT(A2:A9,B2:B9)

°ÝÃD2: ­Y¨S¦³C2:C9¦X­pÄæ®É¡A­n¦p¦ó¨DÁ`­p¡A¦Ó¥B³æ»ù¤j©ó900¤¸ªº¶µ¥Ø
¸Ñµª2: Á`­p =SUMPRODUCT(A2:A9*(A2:A9>900),B2:B9)

ML089

¦^´_  cheukyiu19

¦p§Ú­n§â²Ä¤G­Ó±ø¥ó ¥Ñ¤W¤@­ÓÀx¦s®æ§ï¬° ³sÄò¤W¤T­ÓÀx¦s®æ ³£­n¤j¹L  §Ú¸Ó¦p­Ó¼g¡H
...
cheukyiu19 µoªí©ó 2014-5-16 00:10

     =SUMPRODUCT((A4:A10>10)*(A1:A7>A2:A8)*(A2:A8>A3:A9)*(A3:A9>A4:A10))

cheukyiu19

¦^´_ 5# cheukyiu19

¦p§Ú­n§â²Ä¤G­Ó±ø¥ó ¥Ñ¤W¤@­ÓÀx¦s®æ§ï¬° ³sÄò¤W¤T­ÓÀx¦s®æ ³£­n¤j¹L  §Ú¸Ó¦p­Ó¼g¡H

¥Ha4 §@¨Ò¡A
§Y¬Oa4>10¤Î ¥²¶·a1 >a2 >a3 >a4 ¡I

ÁÂÁ¦UªB¤Í±Ð¾É±Ð¾É

cheukyiu19

¦^´_ 2# Hsieh

ÁÂÁª©¥D¡A½Ð°Ý¥i§_½Ð±Ð¤@¤U sum product ªº¥Îªk¡H

Hsieh

¦^´_ 3# p212

¼Ó¥D»¡©ú¥HA10¬°¨Ò¡AA9¥²¶·¤j©óA10
©Ò¥H¡AA1µLªk¦b¦³¤W¤@®æ¤ñ¸û
©Ò¥H¥u¯àºâA2:A10ªºµ²ªG¡A¦@9­Ó

p212

¦^´_ 2# Hsieh
¶Wª©±z¦n¡I
1¡B±zªº¤½¦¡¦n¹³µLªkº¡¨¬­pºâ­n¨Dªº±ø¥ó¡uÀx¦s®æ­È¶·¤j©ó10¡A¥B¸ÓÀx¦s®æªº¼Æ­È¤ñ¤U¤@®æªº¼Æ­È¤j¡v(2#À³¦³5­Óº¡¨¬­pºâ±ø¥ó¡GA1=30,A2=26,A4=21,A6=21,A7=12)¡FÁÙ¬O¥»¤H»~¸Ñ¤FÃD·N¡H
2¡B¬°¦ó¥u³y9­Ó°}¦C­È¡H
¤½¦¡=SUMPRODUCT(($A$2:$A$10>10)*($A$2:$A$10<$A$1:$A$9))¤§$A$2:$A$10>10¡A¬°¦ó¤£¬O$A$1:$A$10>10¡H
·Ð½Ð½ç±Ð¡AÁÂÁ¡I

Hsieh

¦^´_ 1# cheukyiu19

¤U¸ü (7.87 KB)

2014-5-15 09:56