Results 1 to 10 of 10

Dragging formula down one row, but jumping more than one row data reference

Threaded View

  1. #1
    Registered User
    Join Date
    07-12-2020
    Location
    Tel Aviv
    MS-Off Ver
    version 16.38
    Posts
    4

    Dragging formula down one row, but jumping more than one row data reference

    Hi all,

    I guess you gonna resolved this newbie issue in few lines...

    I have a dataset of 4320 rows for 17 columns.
    Each row is a minute. I want to average my data per hour.
    If I do Average formula which encompass 60 rows, for the first hour it works. But then if I drag the formula down one row it will give me the average of the data +1min, not +60min

    How can I adapt any formula to jump over 60rows each time I drag the formula down one row.

    Thank a lot, it gonna be more than helpful

    Raph

    ps: I add an excel with one of the column and the corresponding averaging I need
    Attached Files Attached Files
    Last edited by Cnidoraph; 07-12-2020 at 10:54 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Dragging formula should reference to another worksheet
    By marckaljonp in forum Excel General
    Replies: 4
    Last Post: 10-30-2016, 09:09 AM
  2. Replies: 4
    Last Post: 08-22-2013, 07:31 AM
  3. Dragging formula (cell reference) across columns
    By theraindew in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-12-2013, 01:51 PM
  4. Dragging formula, change sheet reference, but not cell reference
    By Kalilaya0419 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2013, 04:50 PM
  5. Replies: 5
    Last Post: 09-21-2012, 02:08 PM
  6. Dragging down formula and cell reference
    By JDCONNER in forum Excel General
    Replies: 4
    Last Post: 09-30-2011, 05:05 PM
  7. wrong reference after dragging down a formula
    By Bram in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2005, 12:05 PM

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