+ Reply to Thread
Results 1 to 2 of 2

Autofill Overlapping Averages

  1. #1
    Registered User
    Join Date
    07-19-2019
    Location
    San Francisco, California
    MS-Off Ver
    2016
    Posts
    1

    Autofill Overlapping Averages

    Hello!

    I feel like I'm missing something simple here. I want to average every thirteen rows, with one row of overlap. The formula below lets me average every thirteen rows, but I can't figure out how to add overlap.

    =AVERAGE(OFFSET($B$14,(ROW()-ROW($AB$44))*13,,13))

    For example, I want to average B14-26, then B26-38, then B38-50, and so on. Can anyone help?
    Thank you!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,133

    Re: Autofill Overlapping Averages

    Nearly there!!

    =AVERAGE(OFFSET($B$14,12*(ROWS($1:1)-1),,13,))
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ 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. Trying to calculate daily averages and seasonal averages
    By sorchah in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-03-2018, 11:03 AM
  2. Replies: 10
    Last Post: 11-15-2017, 01:28 PM
  3. Replies: 4
    Last Post: 03-13-2015, 05:34 AM
  4. Replies: 9
    Last Post: 05-15-2014, 01:57 PM
  5. [SOLVED] Autofill non-overlapping increments
    By gray-ish in forum Excel General
    Replies: 3
    Last Post: 07-23-2013, 07:30 PM
  6. Formula, Averages by name, and differences of averages
    By billyvnilly in forum Excel General
    Replies: 3
    Last Post: 02-24-2010, 05:35 PM
  7. Replies: 1
    Last Post: 05-02-2008, 10:41 AM

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