- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 24
- ÂI¦W
- 0
- §@·~¨t²Î
- microsoft
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2012-2-10
- ³Ì«áµn¿ý
- 2019-1-19
|
[µo°Ý] excel¦p¦ó§ä¤£¦P¤u§@ªí¤¤ªº¬Y¤ë³Ì«á¤@µ§¸ê®Æ»P¤é´Á
즳µo©«½Ð¨D°ª¤â¨ó§U¡A¦ý¤£¾å±o¬°Ô£¤£¨£¤F
¦]¦¹«µo¤@¦¸¨D°ª¤âÀ°¦£
§Ú·Qpºâ¬Y°òª÷¸ê®Æªº¤ë³ø¹S
¦ý¤@¨Ç°ÝÃDµLªk§JªA
1.¦p¤é´ÁÄ椤 ¸ê®Æ¬O±qE13¶}©l¡A¤@ª½¨ì¤µ¤Ñ(ÀH®É¶¡§ó·s)
2.²bȧó·s¸ê®Æ¬O©ñ¦b¡y¤u§@ªí1¡z¡A¦ý§Ú¼g¤½¦¡ªº¦a¤è¬O¦b¡y¤u§@ªí¤G¡z
§Ú¸ÕµÛ¼g¤U¦C¤½¦¡
INDEX(INDIRECT("¤u§@ªí1!E14:G"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)),SUMPRODUCT((MONTH(INDIRECT("¤u§@ªí1!E14:E"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)))<=2)*(YEAR(INDIRECT("¤u§@ªí1!E14:E"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)))=2012)*1),3)/INDEX(INDIRECT("¤u§@ªí1!E14:G"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)),SUMPRODUCT((MONTH(INDIRECT("¤u§@ªí1!E14:E"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)))<=1)*(YEAR(INDIRECT("¤u§@ªí1!E14:E"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)))=2012)*1),3)-1
¤]´N¬O (2012¦~2¤ë³Ì«á¤@Ó¤é´Áªº²bÈ)/(2012¦~1¤ë³Ì«á¤@Ó¤é´Áªº²bÈ)-1 =2012¦~2¤ëªº¤ë³ø¹S
¦ý¬O¶]¥X¨ÓªºÈ¦³¿ù¡A¤£ª¾°ÝÃD¦bþ |
|