formula is too long error

w1nter11 · 03-13-2006, 04:00 PM

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)+(AN5*$AN$3)+(AO5*$AO$3)+(AP5*$AP$3)+(AQ5*$AQ$3)+(AR5*$AR$3)+(AS5*$AS$3)+(AT5*$AT$3)+(AU5*$AU$3)+(AV5*$AV$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)+(BM5*$BM$3)+(BN5*$BN$3)+(BO5*$BO$3)+(BP5*$BP$3)+(BQ5*$BQ$3)+(BR5*$BR$3)+(BS5*$BS$3)+(BT5*$BT$3)+(BU5*$BU$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)+(CM5*$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????

Bob Phillips · 03-13-2006, 04:10 PM

=SUMPRODUCT(C5:CN5,$C$3:$CN$3)

Adjust to suit

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"w1nter11" <[email protected]> wrote in message
news:[email protected]...
> 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)+(AF
5*$AF$3)+(AG5*$AG$3)+(AH5*$AH$3)+(AI5*$AI$3)+(AJ5*$AJ$3)+(AK5*$AK$3)+(AL5*$A
L$3)+(AM5*$AM$3)+(AN5*$AN$3)+(AO5*$AO$3)+(AP5*$AP$3)+(AQ5*$AQ$3)+(AR5*$AR$3)
+(AS5*$AS$3)+(AT5*$AT$3)+(AU5*$AU$3)+(AV5*$AV$3)+(AW5*$AW$3)+(AX5*$AX$3)+(AY
5*$AY$3)+(AZ5*$AZ$3)+(BA5*$BA$3)+(BB5*$BB$3)+(BC5*$BC$3)+(BD5*$BD$3)+(BE5*$B
E$3)+(BF5*$BF$3)+(BG5*$BG$3)+(BH5*$BH$3)+(BI5*$BI$3)+(BJ5*$BJ$3)+(BK5*$BK$3)
+(BL5*$BL$3)+(BM5*$BM$3)+(BN5*$BN$3)+(BO5*$BO$3)+(BP5*$BP$3)+(BQ5*$BQ$3)+(BR
5*$BR$3)+(BS5*$BS$3)+(BT5*$BT$3)+(BU5*$BU$3)+(BV5*$BV$3)+(BW5*$BW$3)+(BX5*$B
X$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)+(CL
5*$CL$3)+(CM5*$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????

Biff · 03-13-2006, 04:10 PM

Yoi!

Try this:

=SUMPRODUCT(C5:DZ5,C3:DZ3)

Biff

"w1nter11" <[email protected]> wrote in message
news:[email protected]...
> 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)+(AN5*$AN$3)+(AO5*$AO$3)+(AP5*$AP$3)+(AQ5*$AQ$3)+(AR5*$AR$3)+(AS5*$AS$3)+(AT5*$AT$3)+(AU5*$AU$3)+(AV5*$AV$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)+(BM5*$BM$3)+(BN5*$BN$3)+(BO5*$BO$3)+(BP5*$BP$3)+(BQ5*$BQ$3)+(BR5*$BR$3)+(BS5*$BS$3)+(BT5*$BT$3)+(BU5*$BU$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)+(CM5*$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????

w1nter11 · 03-13-2006, 08:10 PM

Excellent!!!--Thanks a lot!!

"Bob Phillips" wrote:

> =SUMPRODUCT(C5:CN5,$C$3:$CN$3)
>
> Adjust to suit
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "w1nter11" <[email protected]> wrote in message
> news:[email protected]...
> > 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)+(AF
> 5*$AF$3)+(AG5*$AG$3)+(AH5*$AH$3)+(AI5*$AI$3)+(AJ5*$AJ$3)+(AK5*$AK$3)+(AL5*$A
> L$3)+(AM5*$AM$3)+(AN5*$AN$3)+(AO5*$AO$3)+(AP5*$AP$3)+(AQ5*$AQ$3)+(AR5*$AR$3)
> +(AS5*$AS$3)+(AT5*$AT$3)+(AU5*$AU$3)+(AV5*$AV$3)+(AW5*$AW$3)+(AX5*$AX$3)+(AY
> 5*$AY$3)+(AZ5*$AZ$3)+(BA5*$BA$3)+(BB5*$BB$3)+(BC5*$BC$3)+(BD5*$BD$3)+(BE5*$B
> E$3)+(BF5*$BF$3)+(BG5*$BG$3)+(BH5*$BH$3)+(BI5*$BI$3)+(BJ5*$BJ$3)+(BK5*$BK$3)
> +(BL5*$BL$3)+(BM5*$BM$3)+(BN5*$BN$3)+(BO5*$BO$3)+(BP5*$BP$3)+(BQ5*$BQ$3)+(BR
> 5*$BR$3)+(BS5*$BS$3)+(BT5*$BT$3)+(BU5*$BU$3)+(BV5*$BV$3)+(BW5*$BW$3)+(BX5*$B
> X$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)+(CL
> 5*$CL$3)+(CM5*$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????
>
>
>