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

[µo°Ý] ¦Û©w¸q¦WºÙ

¤@¯ë¤½¦¡¦WºÙ
³]©w
=$A$1:$D$10
·|¦Û°ÊÅܦ¨
=Sheet1!$A$1:$D$10
¥u¾A¥Î©ó¸Ó¤u§@ªí

­Y¨C­Ó¤u§@ªí³£»Ý­n³]©w¬Û¦Pªº¦WºÙ®É¡A­×§ï¦p¤U
=!$A$1:$D$10
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# PJChen

¤ñ¸û¹³¦Û­q¨ç¼Æ¡A§A¥i¥H¿é¤J¤½¦¡®É§ä¨ì¥¦¡A

¨Ò¦p ¦WºÙ AA =!$A$1:$$C$3

D1¿é¤J =SUM( «öA´N·|¥X²{ AA´¡¤J¤½¦¡¡A©Îª½±µ¿é¤J¤]¥i¥H)
=SUM(AA)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# PJChen

À³¸Ó¦bÁ`ªíªºÀx¦s®æ«Ø¥ß­n§ìªºÀɮצWºÙ¤Î¸ê®Æ½d³ò
³o¼Ë¤ñ¸û©ú½T
   
ÀɮצWºÙ¡A¸ê®Æ½d³ò¡A¬O§_°õ¦æ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD