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

¦p¦ó¥[Á`§Oªº¤u§@ªí¼Æ¶q

¦p¦ó¥[Á`§Oªº¤u§@ªí¼Æ¶q

¥»©«³Ì«á¥Ñ cchent ©ó 2013-11-19 23:27 ½s¿è

¤p§Ì¦³¤@ªí®æ¤À´²¦b¦U¤u§@ªí¤º·Q±N¥þ³¡ªí®æ²Î­p¦b²Ä¤@¥÷¤u§@ªí¤º
¬O§_¥i¥H§iª¾¤p§Ì¿ù»~¦b¨º

ºÞ®Æ¼Æ¶q²Î­p.rar (14.76 KB)

¦^´_ 1# cchent
«÷¿ù¦r
=SUMPRODUCT(('BF3'!$B7:$B68=B6)*('BF3'!$C7:$C68=C6)*('BF3'!F7:F68))
§ï¦¨
=SUMPRODUCT((B3F!$B7:$B68=B6)*(B3F!$C7:$C68=C6)*(B3F!F7:F68))
§Y¥i

TOP

¦^´_ 2# luhpro


   ÁÂÁÂ
­ì¨Ó¬O§Ú¦Û¤v¥´¿ù¦r

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD