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

[µo°Ý] Sumproduct °ÊºA½d³ò³]©w

[µo°Ý] Sumproduct °ÊºA½d³ò³]©w

¤½¦¡¦p¤U  
ActiveCell = "=sumproduct((AA2:AA4000=AR2)*(AC2:AC4000))"

·Q§â¼Æ­È4000§ï¦¨¬°°ÊºA½d³ò i , ¸Õ¤F¦n¤[³£¤£¦¨¥\, ·Q½Ð±Ð¥ý¶i¦p¦ó­×§ï, ·PÁÂ
  i = Worksheets("AAA").[AA65536].End(xlUp).Row

¦r¦³¥´¿ù¡A¤w¸Ñ¨M¡AÁÂÁ¡C

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD