- ©«¤l
- 15
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 57
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- 32bit
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-11-17
- ³Ì«áµn¿ý
- 2013-9-12
|
§Ú¦Û¤v¸Õ¥X¨Ó¤F¡A³ÌªñN¤Ñªº¤èªk¡A¦pªG¬O7¤Ñªº¤U¤èÂŦâ°Ï´Nn±a6¡A5¤Ñªº´Nn±a4¡C¿é¤J§¹nShift+Ctrl+Enter
=SUM(IF((TODAY()-A1:A7)<N-1,B1:B7))
¦pªG¦³¨ä¥¦¤èªk¤]½Ð¦h«Øij¡AÁÂÁÂ~ |
|