sumproduct°ÝÃD

alexwin

½Ð°Ý¦U¬°¤j¤j,¦¹¤½¦¡

1. =SUMPRODUCT(($P$3:$P$27=$B36)*($G$3:$G$27=D$35)*($H$3:$H$27<>""),$H$3:$H$27)

½Æ»s¥N½X

¤ºªº

1. ($H$3:$H$27<>"")

½Æ»s¥N½X

ºâ¦¡¥\¯à¬O¤°»ò?
¦¹°ÝÃD¬O±q½׾¬ݨì,¦ý¬O§Ú¤£¤F¸Ñªº°ÝÃD?¼ÐÃD¬°"¨â­Ó±ø¥ó¦¡ªº¥[Á`".ºô§}¬° http://gb.twbts.com/index.php?topic=13233.0

alexwin

¦^´_ 10# zz5151353


    ¦^ÂÐ6,7,8,9,10¼Óªº¥ý¶i!
ÁÂÁÂ!³o¤U¥þÁA¤F,¦Ó¥B°¨¤WÀ³¥Î¦b¤u§@¤W¤F!·P®¦£«~

zz5151353

¦]¤u§@¦£¸L,¤µ¤Ñ¤~ª`·N³o¤@¶Kªº°Q½×

=SUMPRODUCT(($P$3¡G$P$27=$B36)*($G$3¡G$G$27=D$35)*($H$3¡G$H$27<>""),$H$3¡G$H$27)

³o¥y  ($H$3¡G$H$27<>"") ¬O¥i¥H¬Ù²¤ªº,¦]¦Ò¼{ªÅªº¦]¯À

¤½¦¡­×­q¦p¤U,´N¥i¥Hº¡¨¬¤F

D36 =SUMPRODUCT(($P$3¡G$P$27=$B36)*($G$3¡G$G$27=D$35),$H$3¡G$H$27)

ANGELA

¨â­Ó¤½¦¡¤¤¥u¦³ , »P * ªº®t§O,­pºâµ²ªG¬O¤@¼Ëªº


·íHÄ榳¤å¦r®É·|¦³®t§Oªº,¤@­Ó·|¥X¿ù,¤@­Ó¤£·|.

asimov

¦^´_  asimov


    ¦]¬°µ¥¯Å¤£¨¬,©Ò¥H§Ú¬Ý¤£¨ìªþ¥ó.¥i¬O§Ú§â²Ä2­Ó¤½¦¡,©ñ¶iexcel±o¨ìªº¬O#value!£°
alexwin µoªí©ó 2010-5-25 18:09

    §Ú¤]¬Ý¤£¨ì¦Û¤v¶Kªºªþ¥ó­C,Áٻݭn¦A§V¤O°Õ

¨â­Ó¤½¦¡¤¤¥u¦³ , »P * ªº®t§O,­pºâµ²ªG¬O¤@¼Ëªº

ªþ¥ó¬Osumproduct¨ç¼Æ¤Þ¼Æ¹ï©ó¨Ï¥Î , »P * arrayªº®t§O
¨Ï¥Î","®Éarray2¤º®e¬O$H$3: $H$27
¨Ï¥Î"*"®Éarray2¤º®e¬OªÅ¥Õ

PD961A

¦^´_ 6# alexwin


¨â­Ó±ø¥ó¦¡ªº¥[Á`".ºô§}¬° http://gb.twbts.com/index.php?topic=13233.0
ÃD¥Ø¤½¦¡©ñ¦bD36
­pºâHÄ檺µ²ªG(HSª©¥D¦^ÂÐ:À³¬O²Å¦X3±ø¥ó¥[Á`hÄ檺­È)

¤U¸ü (17.8 KB)

2010-5-25 20:09

©ñ¶iexcel±o¨ìªºÀ³¸Ó¬O¥¿½Tªº.

alexwin

¦^´_ 4# asimov


    ¦]¬°µ¥¯Å¤£¨¬,©Ò¥H§Ú¬Ý¤£¨ìªþ¥ó.¥i¬O§Ú§â²Ä2­Ó¤½¦¡,©ñ¶iexcel±o¨ìªº¬O#value!£°

alexwin

¦^´_ 3# Hsieh


    ¾é!ÁÂÁÂ!§â

1. ($H$3:$H$27<>"")

½Æ»s¥N½X

§R°£«á,µ²ªG¬O¨Ì¼Ëªº

asimov

¦^´_ 1# alexwin

¤ñ¸û¥H¤Uªº®t²§

1. =SUMPRODUCT(($P$3:$P$27=$B36)*($G$3:$G$27=D$35)*($H$3:$H$27<>""),$H$3:$H$27)
   
2. =SUMPRODUCT(($P$3:$P$27=$B36)*($G$3:$G$27=D$35)*($H$3:$H$27<>"")*$H$3:$H$27)

½Æ»s¥N½X

¤U¸ü (89.88 KB)

2010-5-24 23:59

Hsieh

¦^´_ 1# alexwin


    =SUMPRODUCT(($P$3:$P$27=$B36)*($G$3:$G$27=D$35)*($H$3:$H$27<>""),$H$3:$H$27)
$H$3:$H$27ªº«DªÅ®æ
¦¹¤½¦¡§¹¾ã¸ÑÄÀ
À³¬O²Å¦X3±ø¥ó¥[Á`hÄ檺­È