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

[µo°Ý] ¦p¦ó²Î­p¤å¦rÃþ«¬ªº¡u¼Æ¦r¡v

[µo°Ý] ¦p¦ó²Î­p¤å¦rÃþ«¬ªº¡u¼Æ¦r¡v

¥»©«³Ì«á¥Ñ p212 ©ó 2013-12-30 16:42 ½s¿è

½Ð°Ý¦p¦ó²Î­p¤å¦rÃþ«¬ªº¡u¼Æ¦r¡v¡H½Ð°Ñ¨£¹Ï¥Ü

FIG.JPG (59.01 KB)

FIG.JPG

´£°Ý.zip (8.74 KB)

¦^´_ 1# p212

N3=SUMPRODUCT(($B3:$F3*1>=1)*($B3:$F3*1<=6))
O3=SUMPRODUCT(($B3:$F3*1>=7)*($B3:$F3*1<=12))

TOP

¦^´_ 2# aer
·PÁÂaer¤j¸Ñ´b¡I
¤½¦¡¾ã²z
N3=SUMPRODUCT(($B3:$M3*1>=1)*($B3:$M3*1<=6))
O3=SUMPRODUCT(($B3:$M3*1>=7)*($B3:$M3*1<=12))

TOP

N3 {=COUNT(1/TEXT(B3:M3,"[<7]"))}
O3 {=COUNT(1/TEXT(B3:M3,"[>6]"))}

{..} ªí¥Ü°}¦C¤½¦¡(¿é¤J»Ý¥Î CTRL+SHIFT+ENTER°ÑÁä»ô«ö¿é¤J)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-1-2 09:37 ½s¿è

¦^´_ 4# ML089
½Ð±ÐML089 ¤j
N3 {=COUNT(1/TEXT(B3:M3,"[<7]"))}
¦bformat_text¤¤¬°¦ó¨Ï¥Î¬õ¦r²Å¸¹¡H

TOP

¦^´_ 5# p212

> N3 {=COUNT(1/TEXT(B3:M3,"[<7]"))}
> ¦bformat_text¤¤¬°¦ó¨Ï¥Î¬õ¦r²Å¸¹¡H

[...] ¬O©w¸q±ø¥ó¥Î¡A[<7]ªí¥Ü¥u­n¨ú <7 ªº¼Æ¦r

format_text ¦³¨Ç©_©Çªº¥Îªk¡A¦bHelp¸Ì¨S¦³»¡©ú«Ü²M·¡¡A¥i¥H¦bÀx¦s®æ«ö¥kÁäÀx¦s®æ®æ¦¡¸Ì¥hÆ[¹îEXCEL¤º©w®æ¦¡¬O¦p¦ó³]©wªº¡C
¥ýÂI­n¬Ýªº®æ¦¡¦AÂI¦Û­q¡A´N¥i¥HÅã¥Ü¥X®æ¦¡³]©w¤è¦¡¡A¥Ü½d¦p¤U

{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD