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

[µo°Ý] ½Ð¨D¸Ñµª

[µo°Ý] ½Ð¨D¸Ñµª

½Ð°Ý¦U¦ì¤U¹Ï SUMIF(A2:A7,"*"&"DEF"&"*",B2:B7) ­pºâ±o¥Xµª®×¬O 6
¦ý«Y¦pªG¥Î IF(A3="*"&"DEF"&"*",1,0) ´N¤£¯à±o¥X 1 ªºµ²ªG
¥t¥~·Q°Ý¦pªGÁö­n­pºâ¥H¤U¨C¤@­ÓÀx¦s®æ©Ò¥]§t DEF ³£­n±o¥X1 ªºµ²ªG¤½¦¡¦p¦ó½s¼g?

DEF.gif (12.73 KB)

DEF.gif

¦^´_ 1# ONT


B2=IF(MID(A2,FIND("D",A2),3)="DEF",1,"")

TOP

¦^´_ 1# ONT
=(SUBSTITUTE(A2,"DEF","")<>A2)*1
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

§Úªº³B¤kµo¡A´N¸ÕµÛ¨Ó¦^µª§Aªº°ÝÃD¡A§A°Ñ¦Ò¬Ý¬Ý
SUMIF(A2,"*"&"DEF"&"*",B2)

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD