Averaging numbers within an Array

nohmaste · #1 08-28-2008, 12:50 PM

Hello

I have two columns (two vertical arrays). The first column is time, starting at 9:00 and increasing in one-minute intervals: 9:01, 9:02, 9:03

The second column is an array of numbers. Each minute has a number associated with it:

9:00 44
9:01 47
9:02 44
9:03 49
9:04 50
9:05 49
9:06 50
9:07 47
9:08 46
9:09 44
9:10 42
9:11 43
9:12 51
9:13 43
9:14 44
9:15 43
9:16 44
9:17 45
9:18 42
9:19 42

I would like to average the numbers in ten-minute chunks, like this:

9:00 47
9:10 43.9
9:20 etc
9:30
9:40
9:50

However, I do not want to do it manually. If I simply copy and paste the "AVERAGE(A1:A10)" from the 9:00 cell onto the 9:10 cell, I do not get the correct range of averaged cells.

How do I increment the array index, such that the "AVERAGE" function looks at the correct range of cells?

I hope that makes sense.

Thanks!

**daddylonglegs** · #2 08-28-2008, 01:00 PM

To just average every 10 cells in column B you could use this formula in E1 copied down

=AVERAGE(OFFSET(B$1:B$10,(ROWS(E$1:E1)-1)*10,0))

nohmaste · #3 08-28-2008, 01:18 PM

Thank you so much, Daddylonglegs!

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Averaging numbers while ignoring blank cells.	bjordan	Excel Worksheet Functions	3	12-03-2007 05:09 PM
averaging numbers in 2 rows	doc_bogs	Excel General	5	10-27-2007 09:37 PM
Return an array of numbers	Royker	Excel Worksheet Functions	5	10-16-2007 07:23 PM
Getting Data From User And Storing Into Array	Dan_Dollar	Excel Programming	3	07-13-2007 07:25 PM
summing x numbers in an array	mrlook	Excel General	1	02-01-2007 01:52 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)