Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Average Mulitple Columns

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Washington State, USA
    Posts
    250
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    I have 4 columns with data for every minute of the day (1440 entries)

    In one cell I want to have a running average
    of the data that is available at the time that I ask for it, even if there is no data for the full hour.

    A1:A60,B1:60,C1:60 and D1:60 In e60

    Can any one tell me how to do thisusing the example below with only five minutes of data, with out getting an error.


    A B C D
    22 45 56 98
    12 23 76 98
    12 46 90 98
    33 88 77 66
    22 99 99 89

    Thank you for your time,

    Jim



  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Jim,

    Not sure exactly what you want, but place the following in E1

    =AVERAGE(A$1:D1)

    Make sure that you use the references exactly as shown. Then, copy down your list.

    If each individual column requires it's own average, then use columns E:H and type in the following

    E1: =AVERAGE(A$1:A1)
    F1: =AVERAGE(B$1:B1)
    G1: =AVERAGE(C$1:C1)
    H1: =AVERAGE(D$1:D1)

    and copy down.

    If you need a dynamically changing table, that can be done, too, but will require more work to set up.

    Bye,
    Jay

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Washington State, USA
    Posts
    250
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you very much Jay!

    Jim

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •