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

[µo°Ý] COUNTIFS¤£¥]§t¦hÃöÁä¦r°ÝÃD

¦^´_ 2# msmplay

¤gªk·Ò¿û¤@¤U

=SUM(COUNTIFS(A:A,{"<>*´«³f*","<>*°h³f*","*´«³f*","*°h³f*"},B:B,"*Ãö¾÷­«¶}*")*{1,1,-1,-1})/2

¥t¥~ ¤£¥]§t"´«³f"©Î"°h³f"ÃöÁä¦r ·Pı¤W¼g¦¨ ¤£¥]§t"´«³f"¤Î"°h³f"ÃöÁä¦r ·|¤ñ¸ûºë½T¤@ÂI

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD