| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to take a number from the same cell in multiple sheets then a.
in excell how do I take a number from the same cell in multiple sheets and
then take an average? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to take a number from the same cell in multiple sheets then a.
Hi dinnon
See http://www.rondebruin.nl/linksum.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dinnon" wrote in message ... in excell how do I take a number from the same cell in multiple sheets and then take an average? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to take a number from the same cell in multiple sheets then a.
=AVERAGE(Sheet1:Sheet10!A1)
If your sheets have unique names rather than the standard Sheet1, Sheet2 etc. best to insert a dummy sheet at beginning and another at end. Name these Start and End. Formula will be =AVERAGE(Start:End!A1) Any sheets between Start and End will be included. Gord Dibben MS Excel MVP On Wed, 14 Mar 2007 11:56:00 -0700, dinnon wrote: in excell how do I take a number from the same cell in multiple sheets and then take an average? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search multiple sheets and return largest number found | Excel Worksheet Functions | |||
| How do I add (=Sum) the same cell for multiple sheets (103) | Excel Worksheet Functions | |||
| Number of worksheet tabs as cell value? ie 4 work sheets = 4 cell value | Excel Discussion (Misc queries) | |||
| how can you re-number multiple sheets 'automatically'? | Excel Discussion (Misc queries) | |||
| Automatically number multiple sheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
