+ Reply to Thread
Results 1 to 2 of 2

copying and pasting average formula

  1. #1
    Registered User
    Join Date
    09-10-2014
    Location
    Brisbane, Australia
    MS-Off Ver
    2013
    Posts
    2

    copying and pasting average formula

    HAving difficulty with averaging data.

    Working with large daata block and want to average data in 5 minute intervals to form 15 intervals to match up with over data.

    ie
    1 average(A1,A2,A3)
    2 average(A4,A5,A6)
    3 average(A7,A8,A9)
    4
    5
    6
    7
    8
    9

    want to be able to simply scroll it down the column but when trying the formula goes like the following

    1 average(A1,A2,A3)
    2 average(A2,A3,A4)
    3 average(3,A4,A5)
    4
    5
    6
    7
    8
    9

    Is there an easy fix to this?

    Cheers for any help

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: copying and pasting average formula

    Try this

    =AVERAGE(INDIRECT("A"&ROWS($A$1:A1)*3-2&":A"&ROWS($A$1:A1)*3))
    Cheers!
    Deep Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copying and Pasting a Value Once a Formula Has Run
    By Longknife in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-26-2016, 02:52 PM
  2. Copying/pasting cell value not formula
    By Dervlan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2010, 02:42 PM
  3. Copying and Pasting of Formula
    By calli in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-05-2008, 04:44 PM
  4. Copying/Pasting a Formula with AutoFill...
    By excel03 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2008, 01:04 AM
  5. copying and pasting a formula
    By William in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-21-2005, 08:30 PM
  6. Problem copying and pasting formula
    By Arsenalguy in forum Excel General
    Replies: 2
    Last Post: 10-07-2005, 01:05 PM
  7. [SOLVED] Copying & Pasting Formula
    By Connie Martin in forum Excel General
    Replies: 2
    Last Post: 03-03-2005, 02:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1