Calculating a formula that exceeds 1,000 characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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????
 
Thx a lot!!! Any suggestions on where I can learn more about the sumproduct
function?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
IF 1
formula in excel 2
Excel VBA 1
IF AND Nested Functions - Formula Not Working 0
Need formula 1
Ignore text but not numerics on SUM() function 1
How to ignore text on SUM() function... 16

Back
Top