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

¥Î¥¨¶°¾ã²z¸ê®Æ¡A¦ýsumªº³¡¤À·d¤£©w

¥Î¥¨¶°¾ã²z¸ê®Æ¡A¦ýsumªº³¡¤À·d¤£©w

¤p§Ì¬O·s¤â¡A
§Ú¥Î¥¨¶°¾ã²z½L«á¸ê®Æ¡A
¦b¥[Á`¥­§¡ªº¦a¤è·d¤£©w¡A
¨Ò¦p:
³]7¤é¦¬½L§¡»ù¡A
½Æ»s¶K¤W«á¡A
®æ¤l¤ºªº¤½¦¡´N·|¶]±¼¡A
³Â·Ð½Ðª©¤Wªº¤j¤j«ü¾É¤@¤U¡A
ÁÂÁ¡C

Book2.rar (9.17 KB)

¦^´_ 1# cno
§Aªº·N«ä¬O¡G
  1. Sub ½Æ»s()
  2.     '
  3.     ' ½Æ»s ¥¨¶°
  4.     '
  5.     insert
  6.     Range("G4:L4").Select
  7.     Selection.Copy Range("G6:L6")
  8. End Sub
½Æ»s¥N½X
¶Ü¡H

TOP

L4 =SUM(OFFSET(G4,,,8-ISNUMBER(G5)))/7
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD