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