- ©«¤l
- 13
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 20
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-4-3
- ³Ì«áµn¿ý
- 2011-6-20
|
¦^´_ 6# chanaoho
§Ú̸եX¨Óªº¤½¦¡¦p¤U¡G
C49¡G{=SUMPRODUCT(($B3:$B47="¥[¯Z")*(C3:C47>=3)*3+($B3:$B47="¥[¯Z")*(C3:C47<3)*(IF(ISNUMBER(C3:C47),C3:C47,0)))}
C50¡G{=SUMPRODUCT(($B4:$B47="¥[¯Z")*(C4:C47>3)*(IF(ISNUMBER(C4:C47),C4:C47,1)))}
¦ý®M¨ì¹j¾À´N¦³¿ù¤F¡I¡I |
|