- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2013-8-3 21:24 ½s¿è
¦^´_ 1# qwer7632
´N±z´£¨Ñªº½d¨Ò¸ÑÃD¡A½Ð°Ñ¦Ò¡I
1¡BÀx¦s®æH2¿é¤J¤½¦¡
=SUMIFS($D$2:$D$6,$B$2:$B$6,F2,$C$2:$C$6,G2)
¦V¤U½Æ»s¤½¦¡
2¡BÀx¦s®æH10¿é¤J¤½¦¡
=SUMIF($B$10:$D$14,F10,$D$10:$D$14)
¦V¤U½Æ»s¤½¦¡ |
|