[µo°Ý] ¦p¦ó²Î­p½d³ò¤º¤å¦r(2­Ó·Ç«h±ø¥ó)¥X²{¦¸¼Æ?

erictang

sheet1¸ê®Æ¦p¤U¡J
A1 - §A¦n¶Ü¡A§Ú¦n¡C
A2 - §Ú¦n¡A§Ú¦n¡C
A3 - §A¦n¦n¡A¦­¡C
A4 - §A¦n§Ú¦n¡C§A¦n¡C
A5 - §Ú¦n¡A§A¦n¦n¡H
A6 ¡V §Ú¬O¤H¡A§A¦n/ §Ú¦n¡I§A¦n¡C

Sheet2
A1 ¡V ²Î­p¥XSheet1 A:A ¨C­Ócell¤¤¦³¥X²{¹L¡¨§A¦n¡¨ªº¦¸¼Æ¡C
¦Ó§Ú·|¿é¤J: =COUNTIF(¤u§@ªí1!A:A,"*§A¦n*") ·|±o¥X6

°ÝÃD¡J
¦p§Ú·Q²Î­p¥XSheet1 A:A ¡A·í1­ÓCell¦P¤@®É¶¡¥X²{¡¨§A¦n¡¨¤Î¡¨§Ú¦n¡¨¡C
­n«ç»ò¿ì???? ¨D±Ð~~~

§Ú­nªºµª®×¬O¡J4
¦]A1, A4, A5, A6 ¦P¤@®É¶¡¦³¥X²{¹L¡¨§A¦n¡¨©M¡¨§Ú¦n¡¨¡C

ML089

=COUNTIFS(¤u§@ªí1!A:A,"*§A¦n*", ¤u§@ªí1!A:A,"*§Ú¦n*")

erictang

³Â·ÐML089~~~~~~~¦hÁ§AÀ°¦£~~

erictang

=COUNTIFS(¤u§@ªí1!A:A,"*§A¦n*", ¤u§@ªí1!A:A,"*§Ú¦n*")
ML089 µoªí©ó 2015-11-9 17:10

^^·Q°Ý¦h¤@¼Ë
=COUNTIFS(¤u§@ªí1!A:A,"*§A¦n*", ¤u§@ªí1!A:A,"*§Ú¦n*")
©ó"*§A¦n*"¦ì¸m¡A¦p§Ú¤£¥Î«ü©w¦r¤¸¡A¥i§_§ï¬°=A1¤ºªº¸ê®Æ¡A§Y¥HÀx¦s®æ¦ì¸mªí¥Ü....??

ML089

¦^´_ 4# erictang

B1 = "*§A¦n*"
B2 = "*§Ú¦n*"
=COUNTIFS(¤u§@ªí1!A:A, B1, ¤u§@ªí1!A:A, B2)