excel¥i§_¦Û°Ê§PÂ_¥[Á`¤ë¸ê®Æ
- ©«¤l
- 130
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 162
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-5-7
- ³Ì«áµn¿ý
- 2011-7-16
|
¸g±`°µ³o¼Ë³øªí
¦~/¤ë À禬
98/10/31 123
98/11/30 234
98/12/31 341
99/01/31 34 ...
gong µoªí©ó 2010-6-24 21:25
ª©¥D¤ÓÀu¤F
¤p§Ì¤]´£¨Ñ¤@Ó
°}¦C¤½¦¡
{=SUM((YEAR(A2:A18)=MAX(YEAR(A2:A18)*(B2:B18>0)))*B2:B18)} |
|
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡
|
|
|
|
|