- ©«¤l
- 186
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 218
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-11-12
- ³Ì«áµn¿ý
- 2014-4-15
|
¥»©«³Ì«á¥Ñ Bodhidharma ©ó 2013-4-13 01:26 ½s¿è
¦^´_ 1# lucky_jocky
F4°}¦C¤½¦¡
=SUM(IF(E16:E430="¿ð¨ì",F16:F430,0))
F5°}¦C¤½¦¡
=SUM(IF(E16:E430="¥[¯Z",F16:F430,0))-SUM(IF(E16:E430="¸É®É",F16:F430,0))
(³oÃä¼Æ¶q·|¸ò§A쥻ªº¤£¤@¼Ë¡A¦]¬°§A3/21¥[¯Z5¤p®É¨S¦³¦C¦b"²Îp"Àx¦s®æ¤¤¡AµM«á·í¦~¥[¯Z11¤p®É¡A¸É®É9¤p®É¡AÀ³¸Ó·|¬O2¤p®É¡A§A³o®æ¬On¥[¤W¥h¦~ªº²Öp¡H
F6¬Ý¤£À´
F7°}¦C¤½¦¡
=SUM(IF(E16:E430="¯f°²",F16:F430,0)) |
|