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

Attached Files

Book1.xls (18.0 KB, 13 views)