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

[µo°Ý] COUNTIFS²Î­p½Æ¼Æ±ø¥ó°ÝÃD

¦^´_ 9# msmplay

¦³¿³½ì¨ì¦¹«ü±Ð    2000¦h½g
http://blog.xuite.net/hcm19522/twblog?&p=2

TOP

¥|¸U¦hµ§¡A³Ì¦nÁÙ¬O¥Î»²§U¤½¦¡¡A¥H§K¥dÀÉ¡I¡I
¥t¤@°Ñ¦Ò¡G
=N(COUNT(FIND({"´«³f","DOA"},A2))*COUNT(FIND({"µLªk¶}¾÷","½Ý½u","¾î½u"},B2))*COUNT(FIND({"ªù¥«","ºô¸ô"},C2))>0)

TOP

¦^´_ 11# hcm19522

«D±`·PÁ³áh¤j~~~~~~



¦^´_ 12# ­ã´£³¡ªL

­ã¤j¤]«D±`·PÁ±zªº¼ö¤ß¦^ÂÐ
*¦v¤k¤@ªTµL»~*

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD