ªð¦^¦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 : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD