| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
averaging particular blocks of data
hi, I have 50 consecutive numbers in column A. I want to find the average of any required consecutive block, ie rows 3 to 11, or rows 8 to 51. The numbers of the start and end row are in cells D1 and E1, and change according to data on another sheet. I prefer a formula solution rather than macros, if it can be done. I am trying to understand indirect and address functions as I suspect they may be involved. thanks Robert -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=560642 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
| How do I repeatedly transpose blocks of data? | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Threaded Mode
