|
|
#1
11-24-2010, 01:46 PM
|
|||
|
|||
'AVERAGE' Formula
I am trying to get an average of a single/same cell in several tabs.
I have attached a simple example. I want to have around 50 tabs so the formula will just look stupid if its laid out like this =AVERAGE(Sheet1!B3,Sheet2!B3,Sheet3!B3,Sheet4!B3,S heet5!B3) Can I reduce it? Many thanks Nic 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Average of many rows
|
speedycorn1 | Excel | 1 | 10-30-2010 07:54 PM |
| calculate average depending on drop-down values | virencm | Word | 0 | 08-06-2010 06:10 PM |
|
Help with Formula
|
Corca | Excel | 6 | 02-22-2010 09:40 PM |
|
If formula
|
sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |
| Help for formula | dehann | Excel | 5 | 05-01-2009 10:44 AM |
Windows XP 
Office 2007
Threaded Mode