Formula is too long

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
F

Frank Kabel

Hi
what is the reason for such a long formula:
- too many path information for referenced but closed
workbooks
- complex calculation

One idea could be to define names for specific parts of
your formula and use these names instead. It would be
helpful if you post your current formula
 
Here is the current formul

='Application 1'!C6+'Application 2'!C6+'Application 3'!C6+'Application 4'!C6+'Application 5'!C6+'Application 6'!C6+'Application 7'!C6+'Application 8'!C6+'Application 9'!C6+'Application 10'!C6+'Application 11'!C6+'Application 12'!C6+'Application 13'!C6+'Application 14'!C6+'Application 15'!C6+'Application 16'!C6+'Application 17'!C6+'Application 18'!C6+'Application 19'!C6+'Application 20'!C6+'Application 21'!C6+'Application 22'!C6+'Application 23'!C6+'Application 24'!C6+'Application 25'!C6+'Application 26'!C6+'Application 27'!C6+'Application 28'!C6+'Application 29'!C6+'Application 30'!C6+'Application 31'!C6+'Application 32'!C6+'Application 33'!C6+'Application 34'!C6+'Application 35'!C6+'Application 36'!C6+'Application 37'!C6+'Application 38'!C6+'Application 39'!C6+'Application 40'!C6+'Application 41'!C6+'Application 42'!C6+'Application 43'!C6+'Application 44'!C6+'Application 45'!C6+'Application 46'!C6+'Application 47'!C6+'Application 48'!C6+'Application 49'!C6+'Application 50'!C

I have 83 Applications all of the applications have data which needs to total on a separate worksheet. For instance, each application is for a different person and includes demographic information. Therefore, of the 83 applications I need the total male and female to calculate on a seperate worksheet. However, when I at " 'Application 51'!C6 " excel says formula is too long
 
Hi
use
=SUM('Application 1:Application 83'!C6)

if you want to enter this with the mouse simply enter the
equation sign and select the cell C6 on the first sheet.
Hold down the SHIFT key and select with your mouse all
relevant tab names
-----Original Message-----
Here is the current formula

='Application 1'!C6+'Application 2'!C6+'Application 3'!
Click to expand...
C6+'Application 4'!C6+'Application 5'!C6+'Application 6'!
C6+'Application 7'!C6+'Application 8'!C6+'Application 9'!
C6+'Application 10'!C6+'Application 11'!C6+'Application
12'!C6+'Application 13'!C6+'Application 14'!
C6+'Application 15'!C6+'Application 16'!C6+'Application
17'!C6+'Application 18'!C6+'Application 19'!
C6+'Application 20'!C6+'Application 21'!C6+'Application
22'!C6+'Application 23'!C6+'Application 24'!
C6+'Application 25'!C6+'Application 26'!C6+'Application
27'!C6+'Application 28'!C6+'Application 29'!
C6+'Application 30'!C6+'Application 31'!C6+'Application
32'!C6+'Application 33'!C6+'Application 34'!
C6+'Application 35'!C6+'Application 36'!C6+'Application
37'!C6+'Application 38'!C6+'Application 39'!
C6+'Application 40'!C6+'Application 41'!C6+'Application
42'!C6+'Application 43'!C6+'Application 44'!
C6+'Application 45'!C6+'Application 46'!C6+'Application
47'!C6+'Application 48'!C6+'Application 49'!
C6+'Application 50'!C6
I have 83 Applications all of the applications have data
Click to expand...
which needs to total on a separate worksheet. For
instance, each application is for a different person and
includes demographic information. Therefore, of the 83
applications I need the total male and female to calculate
on a seperate worksheet. However, when I
at " 'Application 51'!C6 " excel says formula is too long
 
You could try widening the column as the total may be too long for your
column width.
 
Back
Top