Formula too long

[Raynette Burrows]

The formula I am inquiring about is
='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

The situation is, I need to add information for up to Application 83 and link it to a seperate worksheet. When I add 'Application 51'!C6 to the original formula excel says formula is too long. HELP!

 

[Frank Kabel]

Hi
see your reply in the original thread

-----Original Message-----
The formula I am inquiring about is:
='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'!C6

The situation is, I need to add information for up to

Application 83 and link it to a seperate worksheet. When
I add 'Application 51'!C6 to the original formula excel
says formula is too long. HELP!

 

[Jason Morin]

Try:

=SUM('Application 1:Application 50'!C6)

HTH
Jason
Atlanta, GA

-----Original Message-----
The formula I am inquiring about is:
='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'!C6

The situation is, I need to add information for up to

Application 83 and link it to a seperate worksheet. When
I add 'Application 51'!C6 to the original formula excel
says formula is too long. HELP!