easy way to do computations across worksheets?

Posted by Coline McConnel on June 21, 2001 3:12 PM

Hi, I have participants' data in about 70 worksheets (which I would like to keep in separate worksheets for various reasons), and I would like to summarize data across all participants. All data are set up so that the cells in each worksheet match up. Basically, I would like to find averages, standard deviations, etc. of data appearing in cell bb5 across 70 worksheets. Is there a non-repetitive way of doing this--especially considering that only 30 arguments are allowed in formulas? Thanks for the help!

Posted by IML on June 21, 2001 3:26 PM

I haven't had a workbook with that many sheets. So you get an error if you try to, say add all cell A1 by using something like:
=SUM(Sheet1:Sheet70!A1)

Just curious, because I think this would only be counted as one argument.

good luck

Posted by Coline McConnel on June 21, 2001 4:11 PM

I knew there was an easy solution! Thanks for your help; I've learned something new today. Cool!