LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
w1nter11
 
Posts: n/a
Default formula is too long error

The formula I am working on needs to calculate the following cell ranges and
values. In column CT this is the formula that I am using.

=(C5*$C$3)+(D5*$D$3)+(E5*$E$3)+(F5*$F$3)+(G5*$G$3) +(H5*$H$3)+(I5*$I$3)+(J5*$J$3)+(K5*$K$3)+(L5*$L$3) +(M5*$M$3)+(N5*$N$3)+(O5*$O$3)+(P5*$P$3)+(Q5*$Q$3) +(R5*$R$3)+(S5*$S$3)+(T5*$T$3)+(U5*$U$3)+(V5*$V$3) +(W5*$W$3)+(X5*$X$3)+(Y5*$Y$3)+(Z5*$Z$3)+(AA5*$AA$ 3)+(AB5*$AB$3)+(AC5*$AC$3)+(AD5*$AD$3)+(AE5*$AE$3) +(AF5*$AF$3)+(AG5*$AG$3)+(AH5*$AH$3)+(AI5*$AI$3)+( AJ5*$AJ$3)+(AK5*$AK$3)+(AL5*$AL$3)+(AM5*$AM$3)+(AN 5*$AN$3)+(AO5*$AO$3)+(AP5*$AP$3)+(AQ5*$AQ$3)+(AR5* $AR$3)+(AS5*$AS$3)+(AT5*$AT$3)+(AU5*$AU$3)+(AV5*$A V$3)+(AW5*$AW$3)+(AX5*$AX$3)+(AY5*$AY$3)+(AZ5*$AZ$ 3)+(BA5*$BA$3)+(BB5*$BB$3)+(BC5*$BC$3)+(BD5*$BD$3) +(BE5*$BE$3)+(BF5*$BF$3)+(BG5*$BG$3)+(BH5*$BH$3)+( BI5*$BI$3)+(BJ5*$BJ$3)+(BK5*$BK$3)+(BL5*$BL$3)+(BM 5*$BM$3)+(BN5*$BN$3)+(BO5*$BO$3)+(BP5*$BP$3)+(BQ5* $BQ$3)+(BR5*$BR$3)+(BS5*$BS$3)+(BT5*$BT$3)+(BU5*$B U$3)+(BV5*$BV$3)+(BW5*$BW$3)+(BX5*$BX$3)+(BY5*$BY$ 3)+(BZ5*$BZ$3)+(CA5*$CA$3)+(CB5*$CB$3)+(CD5*$CD$3) +(CE5*$CE$3)+(CF5*$CF$3)+(CG5*$CG$3)+(CH5*$CH$3)+( CI5*$CI$3)+(CJ5*$CJ$3)+(CK5*$CK$3)+(CL5*$CL$3)+(CM 5*$CM$3)+(CN5*$CN$3)+(CO+CO3)....
I get this far and then it stops with an error message "formula too long".

Ideally, I would like the range to go all the way to DZ to capture data that
I might need at a future date. Can anyone help me with this????
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL ERROR - series formula is too long BobY Excel Worksheet Functions 3 April 3rd 23 10:55 AM
Error formula too long JJT Excel Worksheet Functions 0 December 23rd 05 04:02 PM
Ignore error msgs in formula references gharden Excel Discussion (Misc queries) 4 June 17th 05 12:14 AM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
"formula too long" error message lbaskin Excel Discussion (Misc queries) 1 January 13th 05 03:05 AM


All times are GMT +1. The time now is 11:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"