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

sumproduct«á¦A¥[Á`

sumproduct«á¦A¥[Á`

½Ð°Ý§Úªþªí¤¤, §Úª¾¹D¥Îsumproduct¥h§ä¥X¦³¬Û¦P¤Ø¤oªº²£«~, ¦ý±µ¤U¨Ó¦p¦ó¦A±N¬Û¦P¤Ø¤oªº¼Æ¶q¥þ³¡¥[Á`°_¨Ó©O?

¦³¤H¥i¥HÀ°¦£§Ú¶Ü?  ·PÁÂ!

123.JPG (57.74 KB)

123.JPG

=sumproduct(($a$1:$a$50=a2)*($b$1:$b$50=B2)*($c$1:$c$50=c2)*($e$1:$e$50))
½d¨Ò½Ð¥ÎexcelÀÉ®×,¤Ö¥Îjpg

TOP

¦^´_ 2# ANGELA


    §Ú©ú¥Õ¤F!  ÁÂÁÂ~

    ¦n~ ¤U¦^·|¥Îexcel, ¦A¦¸ÁÂÁÂ~

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD