- ©«¤l
- 22
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 36
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-2-15
- ³Ì«áµn¿ý
- 2014-6-28
|
¥»©«³Ì«á¥Ñ home1913 ©ó 2013-6-6 17:46 ½s¿è
¥Ø«e¥Î³o3Ó¤½¦¡¥X¨ÓªºÈ³£¬O80
={SUMPRODUCT((B2:B7="Á`¤½¥q")*(INT(C2:C7/VLOOKUP(A2:A7,E2:F8,2,))*10+MOD(C2:C7,VLOOKUP(A2:A7,E2:F8,2,))*2))}
={SUM(IF(B2:B7="Á`¤½¥q",INT(C2:C7/VLOOKUP(A2:A7,E2:F8,2,))*10+MOD(C2:C7,VLOOKUP(A2:A7,E2:F8,2,))*2))}
={SUMPRODUCT(ISNUMBER(FIND("Á`¤½¥q",$B$2:$B$7))*(INT($C$2:$C$7/VLOOKUP($A$2:$A$7,$E$2:$F$8,2,0))*10+MOD($C$2:$C$7,VLOOKUP($A$2:$A$7,$E$2:$F$8,2,0))*2))} |
|