Long Formulas

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

I have a workbook that contains information regarding
interest earned on security deposits for a lot of
clients. I believe I may have gotten to the end of being
able to add additional sheets (cell references) to the
formula. Does anyone know how many items can be
calculated in a formula??
Thanks
 
Here you go.....

='Michael Ahearn'!B84+'David Allen'!B84+'Greg Allen'!
B84+'Theresa Antunes'!B84+'Mark Avery'!B84+'Lauri
Beaudette'!B84+'John Benedict'!B84+'Luis Nicolaza
Bermudez'!B84+'Margaret Bourbeau'!B84+'Jessie Brown'!
B84+'Barnard Barlow'!B84+'Elias Cassiel'!B84+'Johanna
Castilla'!B84+'Jamey Chapin'!B84+'Eugene Coleman'!
B84+'Carmen Cosme'!B84+'Milca Cruz'!B84+'Joyce Cunningham'!
B84+'Christine Depault'!B84+'Sarah Dickinson'!B84+'Sandra
Facto'!B84+'Daniel Farrington'!B84+'Nikol Fiske'!
B84+'Daniel Fitzpatrick'!B84+'Jillson Frost'!B84+'Amanda
Gibson'!B84+'James & Kelly Hall'!B84+'Gary Hickey'!
B84+'Areil Jones'!B84+'Karen Kennison'!B84+'Mary
Kuzontkowski'!B84+'Leopoldo Ortiz'!B84+'Margarite Oyola'!
B84+'Ashley Page'!B84+'Timm Phillips'!B84+'Joshua
Phillips'!B84+'Chandra Pierce'!B84+'Renee Randall'!
B84+'Wendy Iris-Rivera'!B84+'Pauline Rouleau'!B84+'Robert
Ryan'!B84+'Gertrude Smith'!B84+'Margaret Stetson'!
B84+'David Turner'!B84+'Leonard Winslow'!B84+Rothwell!
B84+Tabachnikov!B84+'Athina Kopanou'!B84+'Megan Oles'!B84

I'm trying to add someone else and I get the formula too
long error!
Thanks,
 
Denise,

Try

=SUM('Michael Ahearn:Megan Oles'!B84)

or whatever the last sheet is

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Bob,

We'll try that.... Thanks,
Denise
-----Original Message-----
Denise,

Try

=SUM('Michael Ahearn:Megan Oles'!B84)

or whatever the last sheet is

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
Try

=SUM('Michael Ahearn:Megan Oles'!B84)

or whatever the last sheet is
Click to expand...
...

Or insert a worksheet named BeginSum just before the first worksheet to be
included in the sum, and another named EndSum just after the last worksheet to
be included in the sum, then use the formula

=SUM(BeginSum:EndSum!B84)
 
Back
Top