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

¡i¨D±Ï¡jEXCEL ¬¡­¶°ÊºA¥[Á`

¡i¨D±Ï¡jEXCEL ¬¡­¶°ÊºA¥[Á`

¦U¦ì«e½ú¡A¤p§Ì¥Ø«e¦³¤@­Ó°ÝÃD·Q½Ð±Ð¡A¦p¤U¡I
Àɮפ¤¬¡­¶Ã¯¥Ñ1~31 ¦@¦³31­¶
¦b³Ì«áÁ`ªí³B¥i§_Âǥѿé¤J(A1, H1)
¨Ó±±¨î±a¥X³æ¤é¾P°â¶q»P²Ö­pÁ`¾P°â¶q(1¨ì¿é¤Jªº¤é´Á²Ö­p)¡AÁÂÁ«e½ú­Ì¨ó§U¡I





111.zip (9.5 KB)
Kenny

¦^´_ 3# ML089


        ÁÂÁ±zªºÀ°¦£
Kenny

TOP

¦^´_ 2# ANGELA


    ÁÂÁ±zªºÀ°¦£
Kenny

TOP

F3 =SUM(B3:E3)
M3 =SUM(I3:L3)
¤U©Ô

B3 =INDIRECT($A$1&"!RC",)
I3 =SUMPRODUCT(N(INDIRECT(ROW(INDIRECT("1:"&$H$1))&"!"&CELL("address",B3))))
¥k©Ô¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

111.rar (8.52 KB) ©w¸q¦WºÙAA=INDIRECT("S"&$A$1&":S"&$H$1)
S1:S31¶ñ¤J1:31
M3=SUMPRODUCT(N(INDIRECT("'"&AA&"'!F"&ROW(A3))))
©¹¤UCOPY

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD