ªð¦^¦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¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD