- ©«¤l
- 617
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 662
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-3-7
|
¥»©«³Ì«á¥Ñ p212 ©ó 2014-4-3 09:34 ½s¿è
¦^´_ 1# xu123
Sorry¡I¥¼ª`·N¨ì±z¥Îªº¬OOffice 2003
©Ó2#¹Ï¥Ü¡A½Ð×¥¿C2Àx¦s®æ¤½¦¡¬°¤U¦C¤§°}¦C¤½¦¡ (½Ð¥HCtrl+Shift+Enter¿é¤J)
=SUM(IF(Data_1>=D2,IF(Data_1<=E2,Data_2,0),0))
½Ð°Ñ¦Ò¡I |
|