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

[µo°Ý] ½Ð°Ý¸Ó¦p¦ó¤~¯à­pºâ¸ÓÄæ³Ì«á¤­µ§¸ê®Æ

[µo°Ý] ½Ð°Ý¸Ó¦p¦ó¤~¯à­pºâ¸ÓÄæ³Ì«á¤­µ§¸ê®Æ

½Ð°Ý§Ú¦³¤@Äæ¸ê®Æ¨C¹j¤@¬q®É¶¡´N·|¼W¥[¼Æ­È¡A
¤£ª¾¹D¸Ó¥Î¦óºØ¨ç¼Æ¤~¥i°µ¨ì§Ú­nªº»Ý¨D
ÁٽЦU¦ìÀ°¦£¡AÁÂÁÂ

¦^´_ 1# hhh111
­pºâDøó³sÄò¼Æ­Èªº³Ì«á5µ§¼Æ­È
  1. =SUM(OFFSET(D1,COUNTA(D:D)-IF(COUNTA(D:D)>=5,5,COUNTA(D:D)),0,5,1))
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 2# GBKEE


  ¦hÁÂGB¤jªº¦^ÂСA­è­è¸Õ¹L¥i¥H¥Î¤F
ÁÂÁÂ

TOP

¦^´_ 2# GBKEE
²¤Æ¤@¤U
=SUM(OFFSET(A1,MAX(COUNT(A:A)-5,0),0,5))
ss

TOP

=IFERROR(SUM(OFFSET(A1,COUNT(A:A),0,-6)), SUM(A:A))
ss

TOP

­Y¬O¾î¦¡ªí®æ¡A¥­§¡ªºÄæ¦ìºò±µ¦b¼Æ¾Ú«á­±¡A¨C¤é·|·s¼W¤@Äæ¼Æ¾Ú¡Aºâ¨C5¤Ñ¥­§¡©M30¤Ñ¥­§¡¡A³o¼Ë­n«ç»ò°µ¤ñ¸û¦n¡A³Â·Ð¦U¦ìÀ°¦£¡AÁÂÁÂ

¹Ï¤ù 5.gif (13.94 KB)

¹Ï¤ù 5.gif

TOP

¦^´_ 6# jak

§Ú¥u·|ºâ³Ì«á¤­µ§ªº¸ê®Æ¡K
=AVERAGE(OFFSET(K2,0,-1,1,-5))

TOP

¦^´_ 6# jak

²×©ó¸Ñ¥X¨Ó¤F¡A
5¤é§¡ªº¤½¦¡¡G=AVERAGE(OFFSET(K2,0,-1,1,IF(3-COUNTA(1:1)<-5,-5,3-COUNTA(1:1))))
¤ë§¡ªº¤½¦¡¡G=AVERAGE(OFFSET(A2,0,1,1,COUNTA(1:1)-3))
³o¼Ë±q²Ä¤@¤Ñ°_¨ì³Ì«á¤@¤Ñ¡AÀ³¸Ó³£¯àºâ±o¥X¨Ó

TOP

·PÁÂmei27¤j¤jªºÀ°¦£
¥i¥H½Ð±Ð¤j¤j  IF(3-COUNTA(1:1)<-5,-5,3-COUNTA(1:1))¬O¤°»ò·N«ä¶Ü¡H

TOP

¦^´_ 9# jak


=AVERAGE(OFFSET(K2,0,-1,1,IF(3-COUNTA(1:1)<-5,-5,3-COUNTA(1:1))))

¦]¬°¬O­nºâ©¹«e±À5¤Ñªº¸ê®Æ©Ò¥H­n¥Îoffset¡A¦pªG¬Oª½±µ©w¸qªº¸Ü¡A¬O³o¼Ëªº¡G
=AVERAGE(OFFSET(K2,0,-1,1,-5))  
»y·N¬°¡G­pºâ¥­§¡(K2¨º®æ¡A¦P¤@¦C¡A«á¤@Äæ¶}©l¡A§ì¨ú½d³ò¡G1¦C¡A§ì¨ú½d³ò¡G©¹¥ª5Äæ)
¥i¬O¦pªG¬O±q²Ä¤@¤Ñ¶}©l¿é¤J¸ê®Æ¡A¨º5¤é§¡¥ªÃä´N¨S¦³¤­Äæ¥i§ì¡A´NÅܦ¨¶Ã½X¤F¡A©Ò¥H­n§â-5§ï¦¨ÅܼÆ
¤]´N¬O¥Î"IF(3-COUNTA(1:1)<-5,-5,3-COUNTA(1:1)"¥h¨ú¥N-5
³o¼Ë¤@¨Ó¦pªG¥u¦³«e¤G¤Ñªº¸ê®Æ¡A¥L´N§ì¤G¤Ñªº¥­§¡¡A¤@ª½¨ì¶W¹L¤­¤Ñ¤§«á¡A¥L¤~·|¦Û°Ê§ì³Ì«á¤­¤Ñªº¥­§¡¡C

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD