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

Åã¥Ü¨C¦~ªº1¤ë1¤é

¦^´_ 2# ivanyung

a1=DATE(YEAR(TODAY()),1,1)
¦]¬°¤ÏÂЭpºâ¦¸¼Æ³]¦¨1©Ò¥H¤£·|³y¦¨´`Àô°Ñ·Ó
¤£¹L³o¼Ë·|³y¦¨¨ä¥L­n¦Û°ÊÅܤƪºÀx¦s®æ¨S¿ìªk¹F¨ì®ÕªG

½Ð¼Ó¥Dµo°Ý­n±Ô­z²M·¡Á×§K¤£¥²­n²q´ú
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# myleoyes


    A3°}¦C¤½¦¡
{=SUMPRODUCT((MOD(COLUMN($B$1:$IV$1),3)=ABS(MOD(ROW(),2)-1))*IF(ISTEXT($B$1:$IV$1),0,$B$1:$IV$1))}
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD