ªð¦^¦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®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD