Calculating a formula that exceeds 1,000 characters
 

I have a formula that needs to sum the following cell ranges formula ex.
=(C5*$C$3) all the way to (CZ5*$CZ$3). I am assuming it stops because a
formula can only have 1024 characters. Any suggestions????

Calculating a formula that exceeds 1,000 characters
 

How about

=SUMPRODUCT(C5:CZ5,$C$3:$CZ$3)

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"w1nter11" wrote in message
...
I have a formula that needs to sum the following cell ranges formula ex.
=(C5*$C$3) all the way to (CZ5*$CZ$3). I am assuming it stops because a
formula can only have 1024 characters. Any suggestions????

Calculating a formula that exceeds 1,000 characters
 

Thx a lot!!! Any suggestions on where I can learn more about the sumproduct
function?

"Charles Williams" wrote:

How about

=SUMPRODUCT(C5:CZ5,$C$3:$CZ$3)

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"w1nter11" wrote in message
...
I have a formula that needs to sum the following cell ranges formula ex.
=(C5*$C$3) all the way to (CZ5*$CZ$3). I am assuming it stops because a
formula can only have 1024 characters. Any suggestions????

Calculating a formula that exceeds 1,000 characters
 

Check it out in Help. or Google.

SUMPRODUCT is also often used for conditional sums where one of the
arguments is a logical test preceded by -- to turn the False/True into 0/1.


Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"w1nter11" wrote in message
...
Thx a lot!!! Any suggestions on where I can learn more about the
sumproduct
function?

"Charles Williams" wrote:

How about

=SUMPRODUCT(C5:CZ5,$C$3:$CZ$3)

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"w1nter11" wrote in message
...
I have a formula that needs to sum the following cell ranges formula ex.
=(C5*$C$3) all the way to (CZ5*$CZ$3). I am assuming it stops because
a
formula can only have 1024 characters. Any suggestions????