+ Reply to Thread
Results 1 to 4 of 4

Calculate Daily, Weekly & Monthly Averages of daily Data not using Pivot Table

  1. #1
    Registered User
    Join Date
    05-30-2012
    Location
    Accra, Ghana
    MS-Off Ver
    Excel 2007
    Posts
    61

    Question Calculate Daily, Weekly & Monthly Averages of daily Data not using Pivot Table

    Hi guys,

    I have data for number of incoming calls daily from january to August and i want to calculate for daily, weekly and monthly averages this period without using the pivot table. Can you hep m with a formular that can perform this calculation?

    Data form:

    1-Jan-13 200
    2-Jan-13 450
    3-Jan-13 1500....
    all the way to August

    Thanks in advance...

  2. #2
    Registered User
    Join Date
    09-30-2013
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Calculate Daily, Weekly & Monthly Averages of daily Data not using Pivot Table

    Why not use pivot tables? It's the easiest way...
    Without the pivot table, you have to insert additional rows and columns, type several formulas...

  3. #3
    Registered User
    Join Date
    05-30-2012
    Location
    Accra, Ghana
    MS-Off Ver
    Excel 2007
    Posts
    61

    Re: Calculate Daily, Weekly & Monthly Averages of daily Data not using Pivot Table

    Yes yes i know so @maria_valeria23 but i'm very new with pivot tables

  4. #4
    Registered User
    Join Date
    09-30-2013
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Calculate Daily, Weekly & Monthly Averages of daily Data not using Pivot Table

    dont be shy with them! they are very useful.
    Another way would be:
    1. insert 2 new columns: one with the week number and one with Month
    2. add subtotals
    Be careful to sort the data (it should be sorted if you entered it chronologically). also, be careful to choose Average under the Use function dropdown.
    You will need to insert the subtotals twice: once for the week and once for the month. when you insert the second subtotal, uncheck "Replace current subtotals" checkbox.

    You can find the Subtotals under the Data tab, Outline group.
    Maria

+ 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. Calculate daily targets given: month, monthly budget, daily indexes
    By Chuckyrp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2013, 03:30 AM
  2. Calculate monthly, quarterly, and yearly averages from daily data
    By jhound in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2013, 11:16 AM
  3. Formula For Daily, Weekly And Monthly Averages
    By jrusso in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2012, 08:10 PM
  4. Calculate Totals weekly and Monthly from daily Figures
    By mfjanoo in forum Excel General
    Replies: 3
    Last Post: 03-05-2012, 03:06 PM
  5. Need to calculate monthly averages from daily values
    By smiso24 in forum Excel General
    Replies: 2
    Last Post: 07-13-2011, 01:03 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