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

[µo°Ý] SUMPRODUCT½d³ò²Î­p°ÝÃD

[µo°Ý] SUMPRODUCT½d³ò²Î­p°ÝÃD


¥HB2¡BB7¤½¦¡¬°½d¨Ò¡A½Ð°ÝB3:B6¡BB8¡A¦p¦ó¥H½d³ò¤½¦¡²Î­p
¨Ò¦p:
B3»Ý²Î­pEÄæ²Å¦XÃöÁä¦r"-39"¥H¤W~"43"¥H¤U«¬¸¹¼Æ¾Ú
¥]§t"-39"¡B"-40"¡B"-41"¡B"-42"¡B"-43"

B4»Ý²Î­pEÄæ²Å¦XÃöÁä¦r"-46"¥H¤W~"49"¥H¤U«¬¸¹¼Æ¾Ú
¥]§t"-46"¡B"-47"¡B"-48"¡B"-49"

B8»Ý²Î­pEÄæ²Å¦XÃöÁä¦r"-65"¥H¤W«¬¸¹¼Æ¾Ú
¥]§t"-65"¥H¤W


¥H¤W¨D¸Ñ~~~~~~~~ÁÂÁÂ!!!!

´ú¸ÕÀÉ.rar (14.54 KB)
*¦v¤k¤@ªTµL»~*

¦^´_ 1# msmplay
¤½¦¡¦³ÂI½ÆÂø¡A¬Ý¤£¬O«ÜÀ´¡A·Pı°_¨Ó¤]³\¥[¤@­Ó»²§UÄæ¡A§â¤Ø¤o¨ú¥X¨ÓÂন¼Æ¦r¡A¥Îcountifs·|¤ñ¸û²³æ¤@ÂI¡H

TOP

RE: SUMPRODUCT½d³ò²Î­p°ÝÃD

¦^´_ 2# zyzzyva

z¤jÁÂÁ§AËç¡ã§Ú¦A¸Õ¸Õ¡I
*¦v¤k¤@ªTµL»~*

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2016-8-31 11:40 ½s¿è

B2:B8{=INDEX(FREQUENCY(IFERROR(--MID(E$2:E$386,4,2),99),{32,43,49,52,58,60,98}),ROW(A1))
40" «Ü¦h ,¬O§_ÁÙ¦³¨ä¥L±ø¥ó

TOP

B3 =SUMPRODUCT(($D$2:$D$3577="CH")*($F$2:$F$3577<>"¥¼³B²z")*MMULT(--($H$2:$H$3577={"AgentOrder","B2CNoContract"}),{1;1})*(MMULT(--({"°h´«³f","­q³æ¨ú®ø","¨Ó¹q¨ú®ø"}=$G$2:$G$3577),{1;1;1})=0)*(MMULT(--ISNUMBER(FIND("-"&{39,40,41,42,43},$E$2:$E$3577)),{1;1;1;1;1})>0))

¨ä¥L¦Û¦æ­×§ï
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD