+ Reply to Thread
Results 1 to 3 of 3

creating an average?

  1. #1
    Registered User
    Join Date
    07-21-2006
    Location
    Hull, England
    MS-Off Ver
    2007
    Posts
    99

    creating an average?

    Hi all, I´m brand new here
    I am building an excel worksheet that I input 4 different sets of data
    Each set has its own page, and there are 12 pages for each month = 48 pages in total.
    There is an additional page that totals all this information
    Here i need to make an average of one of the sets of data which is the (TOTAL WIN) this average needs to be divided by how many days the data has been inputted for.
    Here is the formula that i have so far - =SUMA(O7)/A7/THE AMOUNT OF DAYS???
    Can any one tell me how this can be done?
    Thanks
    loopiloo

  2. #2
    David Biddulph
    Guest

    Re: creating an average?

    "loopiloo" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Hi all, I´m brand new here
    > I am building an excel worksheet that I input 4 different sets of data
    >
    > Each set has its own page, and there are 12 pages for each month = 48
    > pages in total.
    > There is an additional page that totals all this information
    > Here i need to make an average of one of the sets of data which is the
    > (TOTAL WIN) this average needs to be divided by how many days the data
    > has been inputted for.
    > Here is the formula that i have so far - =SUMA(O7)/A7/*THE AMOUNT OF
    > DAYS???*
    > Can any one tell me how this can be done?


    Why not use the AVERAGE function?
    --
    David Biddulph



  3. #3
    Registered User
    Join Date
    10-19-2004
    Posts
    79
    Thanks for the reply, but can you please tell me how to do this.
    I am not being lazy not looking in the help menu, it is that i am working in Spain and the program is in Spanish! and my Spanish is not the best!
    Thanks again
    loopiloo

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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