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

ºâ­«¶q

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2012-10-17 12:21 ½s¿è

R3

=SUMPRODUCT(($B$3:$H$10&$C$3:$I$10=N3&O3)*ISNUMBER($D$3:$J$10),$D$3:$J$10)

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD