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

¨D§U:EXCEL 2003 ¨S¦³COUNTIFS ¦Pªk¦³¨ä¥¦¨ç¼Æ¥i¥Î¶Ü?

¨D§U:EXCEL 2003 ¨S¦³COUNTIFS ¦Pªk¦³¨ä¥¦¨ç¼Æ¥i¥Î¶Ü?

¤½¦¡¦p¤U,¦³¸ó¤u§@ªí,¤]¦³¦r¦ê
B2=COUNTIFS(ºÞ±±ªí!$L$11:$L$10000,MID($A$1,6,2),ºÞ±±ªí!$E$11:$E$10000,LEFT($A$1,4)&"/"&B$3,ºÞ±±ªí!$U$11:$U$10000,$A4)
¨ç¼Æ§Ú§ï¥Î¤FSUMPRODUCT«ç»ò¸Õ³£¤£¦æ¡A¨D§U°ª¤âÀ°¦£,«D±`·PÁÂÁÂ!

¦^´_ 1# evaho0101
¤W¶Ç¤@¤U½d¨ÒÀɦp¦ó¡H
¤è«K¤j¹Ù¨à¬ã¨s¡AÁÂÁ¡I

TOP

©êºp¸Õ¹L¤FÀÉ®×µLªk¤W¶Ç?

TOP

¦^´_ 3# evaho0101

EXCELÀɮתîÀ£ÁY¬°RAR
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 1# evaho0101

B2=COUNTIFS(ºÞ±±ªí!$L$11:$L$10000,MID($A$1,6,2),ºÞ±±ªí!$E$11:$E$10000,LEFT($A$1,4)&"/"&B$3,ºÞ±±ªí!$U$11:$U$10000,$A4)
§ï¬°
B2=SUMPRODUCT((ºÞ±±ªí!$L$11:$L$10000=MID($A$1,6,2))*(ºÞ±±ªí!$E$11:$E$10000=LEFT($A$1,4)&"/"&B$3)*(ºÞ±±ªí!$U$11:$U$10000=$A4))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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