+ Reply to Thread
Results 1 to 2 of 2

Continuous tracking of weekly averages

  1. #1
    Registered User
    Join Date
    11-12-2021
    Location
    Stockholm
    MS-Off Ver
    2103
    Posts
    1

    Red face Continuous tracking of weekly averages

    Hello! Literal first time using Excel so bear with me.

    I'd like to create a table where I can add an amount each week and it calculates the weekly average. Basically just tracking how much of X I order on average.

    The important part for me is making the process of adding onto it each week easy, without making the sheet look all too messy. Is there a clever way of doing this?




    Thanks in advance!

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: Continuous tracking of weekly averages

    a sample spreadsheet may help us with expected results - see yellow banner at top of screen

    maybe just a date column and then an amount column and then calculates the weekly average in C1
    Attached Files Attached Files
    Last edited by etaf; 11-12-2021 at 12:13 PM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Weekly Rolling Averages?!?!
    By lesandrews86 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-01-2013, 02:21 PM
  2. Non-continuous Averages
    By artiststevens in forum Excel General
    Replies: 15
    Last Post: 02-24-2011, 12:33 PM
  3. Getting weekly averages from hourly data
    By Ash142 in forum Excel General
    Replies: 1
    Last Post: 08-23-2010, 02:36 PM
  4. Weekly/Monthly Averages
    By klindy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-14-2006, 04:24 AM
  5. Weekly/Monthly Averages
    By klindy in forum Excel General
    Replies: 2
    Last Post: 10-13-2006, 02:57 PM
  6. how do i add weekly averages in excel
    By phildav in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2006, 06:35 AM
  7. [SOLVED] Graphing weekly/monthly averages
    By Heidi in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-28-2006, 10:35 AM
  8. Continuous Averages Formula
    By Mof in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2006, 01:23 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