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

¤ëµ²©M¦~µ²¤½¦¡

¤ëµ²©M¦~µ²¤½¦¡

¦~µ².rar (8.96 KB) ½Ð°Ý¦p¦ó­pºâ¤ëµ²©M¦~µ²

¤ëµ²=SUMPRODUCT((TEXT($A$2:$A$366,"yyyy¦~m¤ë")=$I2)*(B$2:B$366))
¦~¸`=SUMPRODUCT((LEFT($A$2:$A$49,4)=LEFT($I2,4))*(B$2:B$49))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

TOP

¦hÁ¨â¦ì°ª¤â±Ð¾É,¤w©ú¥Õ¤F.

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD