- ©«¤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-16 14:12 ½s¿è
¦^´_ 4# like026
Sorry! º|±¼¤F¡u«¤u¡v¦]¯À¡I
§@·~¤ñ¨Ò¤u§@ªí¤§Àx¦s®æB2
=SUMPRODUCT(('§@·~¤é»x-1'!$D$8:$D$19=$A2)*('§@·~¤é»x-1'!$L$8:$L$19)*('§@·~¤é»x-1'!$H$8:$H$19<>"«¤u"))
§@·~¤ñ¨Ò¤u§@ªí¤§Àx¦s®æC2
=SUMPRODUCT(('§@·~¤é»x-2'!$D$8:$D$19=$A2)*('§@·~¤é»x-2'!$L$8:$L$19)*('§@·~¤é»x-2'!$H$8:$H$19<>"«¤u")) |
|