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

sumproduct ¹J¨ìªÅ¥ÕÀx¦s®æ???

sumproduct ¹J¨ìªÅ¥ÕÀx¦s®æ???

¥X²{#value! Book2.rar (9.13 KB) ¤£ª¾¦³¦ó¸Ñ¨M¤è¦¡?

¦^´_  t8899


    ½Ð°Ý ($C$3C$8=O9)/P9  c3:c8 ¤£¬O¼Æ¦r¥i¥H°£p9 ?

($C$3C$8=O9) ¬°ÅÞ¿è§PÂ_¦¡ ...
ML089 µoªí©ó 2014-7-12 09:39


ÁÂÁ«ü¾É

TOP

¦^´_ 3# t8899


    ½Ð°Ý ($C$3:$C$8=O9)/P9  c3:c8 ¤£¬O¼Æ¦r¥i¥H°£p9 ?

($C$3:$C$8=O9) ¬°ÅÞ¿è§PÂ_¦¡µ²ªG¬°true/false, True/False ¹J¨ìºâ³N¹Bºâ®É¦Û°ÊÂà´«¬°1/0¡A
¤@¯ë±`¨£¤èªk
¡]§PÂ_­pºâ¦¡¡^* 1¡B¡]§PÂ_­pºâ¦¡¡^+ 0 Âର 1/0
¡]§PÂ_­pºâ¦¡¡^* ¡]§PÂ_­pºâ¦¡¡^³o¬O AND ­pºâ
¡]§PÂ_­pºâ¦¡¡^+ ¡]§PÂ_­pºâ¦¡¡^³o¬O OR ­pºâ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

Q9 =IF(O9="","",SUMPRODUCT(($C$3C$8=O9)/P9,$L$3L$8,$P$3P$8))
ML089 µoªí©ó 2014-7-11 22:25

§¹¥þ¥¿½T
½Ð°Ý ($C$3:$C$8=O9)/P9  c3:c8 ¤£¬O¼Æ¦r¥i¥H°£p9 ?

TOP

Q9 =IF(O9="","",SUMPRODUCT(($C$3:$C$8=O9)/P9,$L$3:$L$8,$P$3:$P$8))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD