- ©«¤l
- 1405
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1415
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2025-3-14

|
¥»©«³Ì«á¥Ñ hcm19522 ©ó 2016-8-27 11:21 ½s¿è
D3=SUMPRODUCT((LOOKUP(ROW($3:$55),ROW($3:$55)/(¼Æ¾Ú¨Ó·½!B$3:B$55<>""),¼Æ¾Ú¨Ó·½!B$3:B$55)=B3)*(LOOKUP(ROW($3:$55),ROW($3:$55)/(¼Æ¾Ú¨Ó·½!A$3:A$55<>""),¼Æ¾Ú¨Ó·½!A$3:A$55)=LOOKUP(1,0/(A$3:A3<>""),A$3:A3))*¼Æ¾Ú¨Ó·½!D$3:D$55*¼Æ¾Ú¨Ó·½!E$3:G$55)
F3=SUMPRODUCT((LOOKUP(ROW($3:$55),ROW($3:$55)/(¼Æ¾Ú¨Ó·½!B$3:B$55<>""),¼Æ¾Ú¨Ó·½!B$3:B$55)=B3)*(LOOKUP(ROW($3:$55),ROW($3:$55)/(¼Æ¾Ú¨Ó·½!A$3:A$55<>""),¼Æ¾Ú¨Ó·½!A$3:A$55)=LOOKUP(1,0/(A$3:A3<>""),A$3:A3))*¼Æ¾Ú¨Ó·½!D$3:D$55*¼Æ¾Ú¨Ó·½!H$3:P$55)
F3 :½Æ»sD3¤£§t "=" ¨ìF3 ,¥[ "=" ,¦A§ïE$3:G$55-->H$3:P$55 |
|