I need more columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
In fact you don't need to "roll your own" average. this formula also works:

=AVERAGE(Sheet1!A1:A500,Sheet2!A1:A500)
 
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)
Click to expand...
....

And if Sheet1 and Sheet2 were adjacent,

=AVERAGE(Sheet1:Sheet2!A1:A500)

would also work.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Column Limitations 1
exceeding columns limit 2
can I increase excel column numbers to more than 256? 1
Excel Issue with "Average" showing in Status Bar 2
XL2000: Pivot Table Limitations II 3
Maximum Columns 3
Need more columns 3
how do i get more than 256 columns 2

Back
Top