software

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????

How about

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

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

quot;w1nter11quot; gt; wrote in message
...
gt;I have a formula that needs to sum the following cell ranges formula ex.
gt; =(C5*$C$3) all the way to (CZ5*$CZ$3). I am assuming it stops because a
gt; formula can only have 1024 characters. Any suggestions????
Thx a lot!!! Any suggestions on where I can learn more about the sumproduct
function?

quot;Charles Williamsquot; wrote:

gt; How about
gt;
gt; =SUMPRODUCT(C5:CZ5,$C$3:$CZ$3)
gt;
gt; Charles
gt; ______________________
gt; Decision Models
gt; FastExcel 2.2 Beta now available
gt; www.DecisionModels.com
gt;
gt; quot;w1nter11quot; gt; wrote in message
gt; ...
gt; gt;I have a formula that needs to sum the following cell ranges formula ex.
gt; gt; =(C5*$C$3) all the way to (CZ5*$CZ$3). I am assuming it stops because a
gt; gt; formula can only have 1024 characters. Any suggestions????
gt;
gt;
gt;

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

quot;w1nter11quot; gt; wrote in message
...
gt; Thx a lot!!! Any suggestions on where I can learn more about the
gt; sumproduct
gt; function?
gt;
gt; quot;Charles Williamsquot; wrote:
gt;
gt;gt; How about
gt;gt;
gt;gt; =SUMPRODUCT(C5:CZ5,$C$3:$CZ$3)
gt;gt;
gt;gt; Charles
gt;gt; ______________________
gt;gt; Decision Models
gt;gt; FastExcel 2.2 Beta now available
gt;gt; www.DecisionModels.com
gt;gt;
gt;gt; quot;w1nter11quot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a formula that needs to sum the following cell ranges formula ex.
gt;gt; gt; =(C5*$C$3) all the way to (CZ5*$CZ$3). I am assuming it stops because
gt;gt; gt; a
gt;gt; gt; formula can only have 1024 characters. Any suggestions????
gt;gt;
gt;gt;
gt;gt;