#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default running average

Excel 2000

I've got a column of data.

I want the average of that data from the first line through any given line.
I'll give an example below.

How do I enter the cell range easily without having to enter the first cell
over and over again. I tried using "$", it didn't help when I cut and pasted.

example:

data average formula should look like:
2 2 =AVERAGE(A1:A1)
4 3 =AVERAGE(A1:A2)
6 4 =AVERAGE(A1:A3)
8 5 =AVERAGE(A1:A4)
10 6 =AVERAGE(A1:A5)

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default running average

=AVERAGE($A$1:$A1)

and copy down

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"barabpan" wrote in message
...
Excel 2000

I've got a column of data.

I want the average of that data from the first line through any given
line.
I'll give an example below.

How do I enter the cell range easily without having to enter the first
cell
over and over again. I tried using "$", it didn't help when I cut and
pasted.

example:

data average formula should look like:
2 2 =AVERAGE(A1:A1)
4 3 =AVERAGE(A1:A2)
6 4 =AVERAGE(A1:A3)
8 5 =AVERAGE(A1:A4)
10 6 =AVERAGE(A1:A5)

Thanks.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default running average

=average($a$1:a1) and fill down.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"barabpan" wrote:

Excel 2000

I've got a column of data.

I want the average of that data from the first line through any given line.
I'll give an example below.

How do I enter the cell range easily without having to enter the first cell
over and over again. I tried using "$", it didn't help when I cut and pasted.

example:

data average formula should look like:
2 2 =AVERAGE(A1:A1)
4 3 =AVERAGE(A1:A2)
6 4 =AVERAGE(A1:A3)
8 5 =AVERAGE(A1:A4)
10 6 =AVERAGE(A1:A5)

Thanks.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running Average to Date Balzyone Excel Discussion (Misc queries) 4 March 1st 07 08:44 PM
creating a running average Jay New Users to Excel 1 November 23rd 06 02:43 AM
Running Average Scott W New Users to Excel 1 April 16th 06 03:28 AM
Running Average lsmft Excel Discussion (Misc queries) 5 March 28th 06 10:44 PM
Running a Daily MTD average. Mike Punko Excel Worksheet Functions 4 August 12th 05 07:24 PM


All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"