| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
I am trying to average a column from cell 1 to the most recently added cell.
A1 is the constant cell. All succeeding cells are to be averaged from A1. However, when I copy and paste, both numbers change (A1:A2 - A2:A3 - A3:A4). What I need is a constant A1 (A1:A2 - A1:A3 - A1:A4). Any ideas would be appreciated!  |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
Hi!
Try this: =AVERAGE(A$1:A2) Copy down as needed. This will increment as you copy: =AVERAGE(A$1:A2) =AVERAGE(A$1:A3) =AVERAGE(A$1:A4) =AVERAGE(A$1:A5) Biff "Colfax" <(E-Mail Removed)> wrote in message news:5223812D-A812-4440-A3BD-(E-Mail Removed)... >I am trying to average a column from cell 1 to the most recently added >cell. > A1 is the constant cell. All succeeding cells are to be averaged from A1. > However, when I copy and paste, both numbers change (A1:A2 - A2:A3 - > A3:A4). > What I need is a constant A1 (A1:A2 - A1:A3 - A1:A4). Any ideas would be > appreciated! |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I get "CONSTANT" behavior from a variable (Constant magic)? | bobg.hahc@gmail.com | Microsoft Access Form Coding | 19 | 7th Feb 2008 04:38 AM |
| How can I get "CONSTANT" behavior from a variable (Constant magic)? | bobg.hahc@gmail.com | Microsoft Access VBA Modules | 3 | 5th Feb 2008 08:04 PM |
| selecting a group of records that have a constant average | jseger22@yahoo.com | Microsoft Access Queries | 10 | 12th Jul 2007 10:21 AM |
| constant variable | =?Utf-8?B?dGlt?= | Microsoft Access | 14 | 6th Apr 2006 02:00 PM |
| Re: Constant or variable? | RobFMS | Microsoft Access Form Coding | 2 | 15th Jul 2003 01:41 PM |
