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

²¤ÆSumproduct

²¤ÆSumproduct

¥»©«³Ì«á¥Ñ yc1031 ©ó 2015-11-9 15:54 ½s¿è

¦U¦ì¦n,


·Q½Ð°Ý¤@¤Usumproductªº¨ç¼Æ, §Ú§â¤T­Ó°Ï°ìªº¼Æ¦r¥ÎsumproductÁ`©M¤F, ¦ý¦pªG·í¤¤¤@­Ó°Ï°ì·s¼W¦W¦r, ¨º§Ú°Ï°ì¤S­n­«³]
©Ò¥H·Q½Ð°Ý¦³¨S¦³¿ìªk¥i¥H¸Ñ¨M©O?   Ãþ¦p§Ú¥u»Ý­n³]¤@­Ó¤j½d³ò, ¤¤¶¡¤£ºÞ¦p¦ó¼W´î¤H­û³£¥i¥H, ¤£¹L³o¼Ë¤@¨Ó·|¦³ªÅ®æ©M¤¤¤å¦rªº°ÝÃD, sumproduct·|§ì¤£¥X¨Ó..

¦A³Â·Ð¦U¦ì¬ÝÀ°¦£¤@¤U, ÁÂÁÂ

SUMPRODUCTªº­pºâµ²ªG­n¦b D72:H74

SUMPRODUCT ¸õ¹LªÅ®æ&¤¤¤å¦r.rar (61.53 KB)

¢Ñ¢¶¢±¡G=COUNTIF($B$2:$B$68,A72)¡@¤U©Ô
¢Ò¢¶¢±¡G=SUMIF($B$5:$B$68,$A72,D$5:D$68)¡@¥k©Ô¤U©Ô

TOP

¦^´_ 2# ­ã´£³¡ªL


  ·PÁÂ, ­ì¨Ó¤£¥Îsumproduct°µ..-_-

¦A¦¸ÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD