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

[µo°Ý] ¦C¹ï¦Cªº¤ñ¹ï¤½¦¡

[µo°Ý] ¦C¹ï¦Cªº¤ñ¹ï¤½¦¡

¤ñ¹ï¤½¦¡.png
2019-1-15 12:28


½d¨ÒªþÀÉ :
¤ñ¹ï¤½¦¡.rar (3 KB)

=SUM(N(MMULT(N(COUNTIF(OFFSET(J$1:N$1,ROW($1:$14),),P2:S2)>0),{1;1;1;1})=4))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

ª©¥D:
¤½¦¡´ú¸ÕOK!
ÁÂÁ±zªº½ç±Ð©MÀ°¦£!
·P®¦!

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD