- ©«¤l
- 144
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-26
- ³Ì«áµn¿ý
- 2023-6-23
|
¥»©«³Ì«á¥Ñ vvcvc ©ó 2012-4-7 00:24 ½s¿è
¦b³oÓ°ÝÃDªºÀɮפ¤¨ä¹êÁÙ¦³¤@Ó¤À¶¥Î¨Ó¿é¤Jraw data
¦b¨C¤@¤Ñªº¸ê®Æ²Îp®æ¤l¸Ì¥Îªº¤½¦¡¦p¤U
=SUMPRODUCT((µn°Oªí!$I$6:$I$9999=$B97)*(µn°Oªí!$N$6:$N$9999=--(LEFT(E$16,1))))
$I$6:$I$9999¬Oraw data¤¤¤é´ÁÄæ¦ì¡A¥Î¨Ó©Mpºâªº¤À¶¤ñ¹ï¤é´Á¥Hpºâ¦¸¼Æ
¤µ¤Ñµo²{¤@Ó°ÝÃD
¦pªG§Ú$I$6:$I$9999ªº¤é´Á¦]¦P¤@¤Ñnµn°O¦hµ§°O¿ý
©ó¬O¥¼¤@®æ¤@®æ¶ñ¤J¤é´Á¦Ó¬Oª½±µ±N¸ê®Æ¦V¤U©Ô
¨Ï¥Î¤W¤èªº¤½¦¡´N·|»{¤£¥X¤U©ÔªºÄæ¦ì
Y¤@®æ¤@®æ¿é¤J«h¨S¦³°ÝÃD
³o¬O¤°»òì¦]?
쥻¥H¬°¦b$I$6:$I$9999«e¥[¤@Ódatevalue§â¨º¨ÇÀx¦s®æªºÈ±j¢Âন¤é´Á¨Ó¸òBÄ檺¤é´Á¤ñ¹ï
¦ý¦ü¥G¬O¦]¬°datevalue¤£¬O°}¦C¤½¦¡¦Ó¥¢±Ñ
¦³¤°»ò¤èªk¥i¥H¸Ñ¨M¶Ü? |
|