| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to average one constant # to variable #s? A1:A2 A1:A3 A1:A4
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average last 17 cells (variable) | New Users to Excel | |||
| average last 17 cells (variable) | New Users to Excel | |||
| 2 Variable Graph - want average line??? | Charts and Charting in Excel | |||
| calc constant date from variable date & return with ability to rn. | Excel Worksheet Functions | |||
Threaded Mode
