- ©«¤l
- 40
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 72
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-19
- ³Ì«áµn¿ý
- 2024-10-28
|
¦U¦ì«e½ú¦n¡G
·Q½Ð°Ý¤j®a¦WºÙ¨Ï¥Î°ÊºA½d³ò®É¹J¨ìªº°ÝÃD¡A
¦]¬°A¼Æ¾Ú©¹«á¦³»Ýn·s¼W¥[¥Ò9¡B¥Ò10µ¥µ¥¤£½T©w¦WºÙӼơA©Ò¥H·Q¥Î°ÊºA½d³òªº¦WºÙ¡A
¥Ø«e°ÊºA½d³ò¼gªk=OFFSET(¤u§@ªí1!$A$3,0,0,COUNTA(¤u§@ªí1!$A$3:$A$10),1)
¦ý¦]¬°¤S¦³¥t¥~ªºB¼Æ¾Ú±µ¦bA¼Æ¾Ú¤U¤è¡A
©Ò¥H·í§Ú¦bA11´¡¤J¥Ò9®É¡A°ÊºA½d³ò¦]¬°§Ú¥Î¤FCOUNTA(¤u§@ªí1!$A$3:$A$10)¡A
¤]´N¤£·|¯Ç¤J¥Ò9¤F.......
§Úª¾¹D¥i¥H§âB¼Æ¾Ú·h¨ì¤u§@ªí2¡AµM«á§ï¦¨COUNTA(¤u§@ªí2!$A$A)¡A
¦ý¦pªG¤£§Æ±æÅÜ°ÊABC¼Æ¾Úªº¥Ø«eÂ\©ñªº®æ¦¡¡A
¦³¥i¯à¨Ï¥Î°ÊºA½d³ò¨Ó¹F¦¨¥i¥H¥ô·N·s¼W¥Ò9¡B¥Ò10¡AµM«áÅý¦b·J¾ãªíªºSUMPRODUCT¤½¦¡¤£¥Î¤@ª½§ï¡C
¥ýÁÂÁ¦U¦ì«e½úªºÀ°¦£¡I¡I
°ÝÃD.zip (10.14 KB)
|
|