Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Selection and Averaging
I have some data that is listed in the lower portion of a worksheet
(rows 201+) and want to grab it based on user input into a cell. I also want to calculate an average of that data. ie Value Start 30 lookup value for 30 End 60 lookup value for 60 Average calculate average for 30-60 Is there a way to say =B(200 + value of Start), =B(200+End), =average(B(200+start):B200+end))? I could just do it =B230 =B260 =average(B230:B260), but having it update would be much easier I can do a lookup on the Start and End data, but the average is not as easy. Thanks Todd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averaging data with errors | Excel Worksheet Functions | |||
averaging data | Excel Discussion (Misc queries) | |||
Averaging data | Excel Worksheet Functions | |||
incremental averaging of data | Excel Discussion (Misc queries) | |||
Averaging only cells with data | Excel Discussion (Misc queries) |