ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¤£¦P¦Cª÷ÃB¬Û­¼¥[Á`°ÝÃD

¥»©«³Ì«á¥Ñ 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

TOP

¦^´_ 5# msmplay
½Ð±Ð¤G°ÝÃD
¤@ .À£ÁYÀɦp¦ó°µ §Ú¸gYAHOO FUNP ³B²z¤U¸ü«ÜºC   ¤G .SINGNATURE ©³¤U¤å¦r ¦p²£¥Í

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD