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

¥Î¤é´Áªº"¦~¥÷"¨ú±o¸ê®Æ

¥Î¤é´Áªº"¦~¥÷"¨ú±o¸ê®Æ

¦è¤¸©M¥Á°ê.rar (9.25 KB)

¢Ö¢´¡D°}¦C¤½¦¡¡G¥k©Ô¤U©Ô
=IFERROR(SMALL(IF(YEAR($A$5:$A$11)=YEAR(H$1),$D$5:$D$11),ROW($A1)),"")

­Y¥u¬O­n²Î­p¦U¦~«×¡G
¢Ö¢±¡D¤@¯ë¤½¦¡¡G¥k©Ô
=SUM(SUMIF($A:$A,">="&DATE(YEAR(H1),{1,13},1),$D:$D)*{1,-1})
¡@

°}¦C¤½¦¡¡G«ö¦ì¡eShift + Ctrl¡f¤£©ñ ¡÷ ¡eEnter¡f

TOP

·PÁÂ.¥Ø«e´ú¸Õ¥i¥H¤F.­Y¦³°ÝÃD¦A½Ð«ü±Ð

TOP

¦^´_ 2# ­ã´£³¡ªL


    H5ªº¤½¦¡§Ú´ú¸ÕÀ³¸Ó¬O¤£¥Î"°}¦C"¤ñ¸û²Å¦X§Úªº¶·¨D
½Ð°Ý¤½¦¡³Ì«áªºROW($A1)¬O¤°»ò·N«ä,§Ú®M¥Î¨ì§Úªºªí®æ¦³ÂI°ÝÃD,¦pªþ¥ó(¤u§@ªí2)
³Â·Ð§A.ÁÂÁÂ
·s¼W.rar (24.76 KB)

TOP

¦^´_ 4# p0078


ROW($A1) ¬°§Ç¸¹¡A¤U©Ô»¼¼W¡A¨Ì¦¸¨ú¥X²Ä¢°¡ã¡H¡Hµ§¡A
³o¤½¦¡¬O°}¦C¡A¤£¨Ï¥Î¤TÁä´N¤£¥¿½T¡ã¡ã

TOP

¦^´_ 4# p0078

P14 =IF(YEAR($B14)=YEAR(P$1),$F14,"")
¥k©Ô¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

·PÁ¤G¦ì.¥Ø«e´ú¸Õ¤¤­Y¦³¨ä¥L°ÝÃD¦A³Â·Ð¦U¦ì«ü¥¿

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD