I need more columns
 

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

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)




On Sat, 22 Jan 2005 09:57:04 -0800, "dilbert"
wrote:

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

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

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


On Sat, 22 Jan 2005 12:14:56 -0600, Myrna Larson
wrote:

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)




On Sat, 22 Jan 2005 09:57:04 -0800, "dilbert"
wrote:

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

"Myrna Larson" wrote...
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.