More arguments than 30?

Posted by Chuck Dunning on September 24, 2001 6:26 AM

Hi,

I'm re-writing on a multisheet workbook for tracking appointments in our office. In order to do this, I would like to be able to enter more than 30 arguments for a cell. Is there any way that I can do that?

Thanks,
Chuck

Posted by . on September 24, 2001 6:29 AM

More details needed

Posted by Chuck Dunning on September 24, 2001 6:42 AM

Re: More details needed

The workbook tracks the appointments of seven college personnel. There are 13 worksheets for each individual, one for each month plus a summary sheet. I'm trying to do an overall summary of appointment activity by semester, and the spring semester has five months.

On my spring semester summary page, I have cells corresponding to cells on each of the individual's monthly worksheets that record the number of appointments by type. We'll call that cell B3. In order to get an accurate total for the B3 of my spring summary, I need to enter an argument for each of the corresponding cells on the 7 individuals' 5 monthly worksheets.

Example: =SUM('CHER-JAN'!B3,'CHER-FEB'!B3,'CHER-MAR'!B3,'CHER-APR'!B3,'CHER-MAY'!B3,...

The problem is that doing so would require 35 arguments, but Excel is automatically limiting me to 30. Is there some way around this problem, wothout having to create a separate spring summary for each individual?

Thanks,
Chuck

Posted by Jeff Larson on September 24, 2001 7:02 AM

Re: More details needed

If the cell is always "B3", you can consolidate the entries in the sum formula.
=SUM('CHER-JAN:CHER-MAY'!B3)

The above formula reduces five arguments to one. Your limitations are that you must be summing the same cell on each sheet and you must specify a consecutive range of sheets.

Posted by Chuck Dunning on September 24, 2001 9:38 AM

Re: More details needed

Thanks, Jeff!