Calculating a formula that exceeds 1,000 characters

W

w1nter11

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

w1nter11

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

Charles Williams

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
 
Top