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

[µo°Ý] ¤½¦¡Â²¤Æ½Ð¯q

[µo°Ý] ¤½¦¡Â²¤Æ½Ð¯q

¥Ø«e¤½¦¡¦p¤U
=COUNTIFS('raw data'!C:C,C8,'raw data'!H:H,"³ø¼o",'raw data'!K:K,"O")+COUNTIFS('raw data'!C:C,C8,'raw data'!H:H,"¹s¥ó",'raw data'!K:K,"O")+COUNTIFS('raw data'!C:C,C8,'raw data'!H:H,"·å²«",'raw data'!K:K,"O")

°£¤FH:H³o­Ó¦ì¸m·Q¦P®É­pºâ¤TºØ±¡ªp"³ø¼o"¡B"¹s¥ó"¡B"·å²«"¥~¨ä¥LÄæ¦ì±ø¥ó§¡¬Û¦P
¤£ª¾¬O§_¦³¤èªk¥i¥H¤£¥Î³o¼Ë¤l²Â²Âªº¼g¤F3­Ó¤½¦¡¦A¬Û¥[?
¤£¤@©w­n¨Ï¥Îcountifs...¥u¬O§Ú¹ï³o­Ó¨ç¦¡¤ñ¸û¼ô¡A¤@®É¶¡°£¤Fsumproduct¥~¤]·Q¤£¥X¨ä¥L¥i´À¥Nªº¨ç¦¡(¨ä¹ê§Úªº°ÝÃD¥Îsumproduct¤]¬O¤@¼Ë­n3­Ó¦¡¤l¬Û¥[)

·PÁ¦^´_

TOP

=SUM(COUNTIFS('raw data'!C:C,C8,'raw data'!H:H,{"³ø¼o","¹s¥ó","·å²«"},'raw data'!K:K,"O"))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

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