+ Reply to Thread
Results 1 to 2 of 2

get data from same days and calculating the sum ,average ,max and min

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    06-23-2012
    Location
    tehran,iran
    MS-Off Ver
    Excel 2010
    Posts
    179

    Unhappy get data from same days and calculating the sum ,average ,max and min

    Hi every body
    I attach a file for my problem then could you plz help me on it and solving my problem by editing on it
    The file which I attach is a sample from my main file .
    the main file contain about 14500 rows and 12 columns
    I want get average and some function like that from my data base on each day
    if I get average from column (amount) my result is not correct because I want get average of the data which related of each days
    not average of total data
    I show you in my sample file manually but for 14500 rows it is very dificult that I do manually I need a code or something like that
    to help me on calculating all of my database
    thanks in advansed for your attention and help
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: get data from same days and calculating the sum ,average ,max and min

    Use Pivot Table, Refer the attached file for details
    Attached Files Attached Files


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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. [SOLVED] Calculating Average Days overdue per department
    By greeneggsandsam in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2014, 02:01 PM
  2. Calculating average of last 5 data
    By chuanyew in forum Excel General
    Replies: 2
    Last Post: 03-18-2013, 02:15 PM
  3. help calculating average days between 3 dates
    By quickbrwnfox in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-11-2009, 12:16 AM
  4. Average data for last 30 days
    By earthtodan in forum Excel General
    Replies: 8
    Last Post: 07-16-2008, 04:35 PM
  5. Calculating Average Days
    By ooZooM in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-27-2006, 09:18 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