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

COUNTIFS¸óÄæ²Î­p°ÝÃD

COUNTIFS¸óÄæ²Î­p°ÝÃD

:D «¢~~~~~~§A­Ì¤@©wı±o§Ú«ÜÄø

´N¬O¥H¤UCOUNTIFS¤½¦¡¡ABÄæ¸òCÄæ­n«ç»ò¦X¨Ö¦¨¤@­Ó¤½¦¡¤@°_²Î­p¤X!?¼P~~~~~~~

=SUM(COUNTIFS($A:$A,"*´ú¸Õ*",$B:$B,{"#123","123#"}))+SUM(COUNTIFS($A:$A,"*´ú¸Õ*",$C:$C,{"#123","123#"}))

¦ý¦pªGBÄæ¸òCÄæ¸Ó¦C¦P®É³£¦³"#123"©Î"123#"ªº¸Ü¡A¤]¥uºâ1³á!! ¤@¦C¤£¯à­«½Æ­pºâ¬°2

¤p©f´N¬O¦]¬°Â椣·|~~~~~~~¦]¬°´ú¸Õ¥H¤U¤½¦¡¦n¹³¤]³£¤£¹ï!!xD
=SUM(COUNTIFS($A:$A,"*´ú¸Õ*",$B:$C,{"#123","123#"}))
=SUM(COUNTIFS($A:$A,"*´ú¸Õ*",$B:$B&$C:$C,{"#123","123#"}))
*¦v¤k¤@ªTµL»~*

¦^´_ 1# msmplay

«Ü®z«Üªøªº¤@ªø¡A¬Ý±z¦³¨S¦³¥Î¡A¤]¥i¥H½Ð¨ä¥L¤j®v¬Ý¬Ý
=IF(SUMPRODUCT((A:A="´ú¸Õ")*((B:B="#123")+(B:B="123#")))>=SUMPRODUCT((A:A="´ú¸Õ")*((C:C="#123")+(C:C="123#"))),SUMPRODUCT((A:A="´ú¸Õ")*((B:B="#123")+(B:B="123#"))),SUMPRODUCT((A:A="´ú¸Õ")*((C:C="#123")+(C:C="123#"))))
¤Ñ¤ÑªÅªÅ°Ú~

TOP

¦^´_ 2# leirex1201

l¤j~~«D±`·PÁ£¬¡IÁöµM¤½¦¡¯uªº¦³ÂIªø~~
*¦v¤k¤@ªTµL»~*

TOP

°}¦C¤½¦¡(¤TÁä):
=COUNT(0/FIND("´ú¸Õ",A1:A99)/MMULT(1-ISNA(MATCH(B1:C99,{"#123";"123#"},)),{1;1}))

TOP

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

ÁÂÁ­ã¤j¼ö¤ß¦^ÂÐ~~~~~~
*¦v¤k¤@ªTµL»~*

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD