Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Referencing Variables
I would like to set up two cells that contain a begin number and an end
number representing a range of rows. I want to then concatenate a column letter onto the start and end number so that I can average the values in the range. For Example: If Column A contains values in rows 1 through 10 I would like to Name "Start" equal to A11 and put 1 in A11 and Name "End" = A12 and put 10 in A12 and then do something like =AVERAGE("A" & Start & ":" & "A" & End) to get the average of cells A1 through A10. I get #VALUE! indication |
#2
|
|||
|
|||
Hi
=AVERAGE(INDIRECT("A" & Start & ":" & "A" & End)) and 'name' these cells with 'Insert - Name - Define' -- Regards Frank Kabel Frankfurt, Germany "Dwinmac" schrieb im Newsbeitrag ... I would like to set up two cells that contain a begin number and an end number representing a range of rows. I want to then concatenate a column letter onto the start and end number so that I can average the values in the range. For Example: If Column A contains values in rows 1 through 10 I would like to Name "Start" equal to A11 and put 1 in A11 and Name "End" = A12 and put 10 in A12 and then do something like =AVERAGE("A" & Start & ":" & "A" & End) to get the average of cells A1 through A10. I get #VALUE! indication |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Referencing | Excel Discussion (Misc queries) | |||
Two variables | Excel Discussion (Misc queries) | |||
Use variables for a chart | Charts and Charting in Excel | |||
vlookup function in excel referencing an access table | Excel Worksheet Functions | |||
Graphs and sheet referencing? | Excel Worksheet Functions |