Average Mulitple Columns

[jeh]

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

 

[Jay Petrulis]

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

 

[jeh]

Thank you very much Jay!

Jim