I need more columns

D

dilbert

What if you need more than 256 columns?
I cannot link the worksheet pages either because I am averaging the numbers
 
M

Myrna Larson

256 is the limit in Excel.

You can write an average formula, though it's more work, e.g.

=SUM(Sheet1!A1:A500,Sheet2!A1:A500)/COUNT(Sheet1!A1:A500,Sheet2!A1:A500)
 
M

Myrna Larson

In fact you don't need to "roll your own" average. this formula also works:

=AVERAGE(Sheet1!A1:A500,Sheet2!A1:A500)
 
H

Harlan Grove

Myrna Larson said:
In fact you don't need to "roll your own" average. this formula also works:

=AVERAGE(Sheet1!A1:A500,Sheet2!A1:A500)
....

And if Sheet1 and Sheet2 were adjacent,

=AVERAGE(Sheet1:Sheet2!A1:A500)

would also work.
 
Top