#1
|
|||
|
|||
'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 |
#2
|
|||
|
|||
A bit by-the-by but if it makes any difference...the tabs will read:
Tax wk 1, Tax wk 2, Tax wk 3 etc etc, to 52 Thanks |
#3
|
|||
|
|||
In the cell where the formula should live:
=AVERAGE('Tax wk 1:Tax wk 52'!B3) FYI, Your life will get easier if you will resist the urge to divide data up onto multiple sheets unnecessarily. This is called horizontal partitioning and it leads to trouble. |
#4
|
|||
|
|||
Thanks for the post, simple when you know how.
and thanks for the tip too, will do my best. At least I'm not working in days Thanks Nic |
Thread Tools | |
Display Modes | |
|
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 |