software

I'm working with the SUMPRODUCT function.

If I highlight a cell containing a SUMPRODUCT formula, amp; press the formula (paste
function) key 'fx', it shows me the arrays I've entered. Now, it also shows me the first
array RESULTS to the right of each formula, like
={0;0;1;0;0; ... and so on.

This is very useful. Is there a debug feature, or some way, for me to see more of the
array results?

Thanks,

Bill.
Hi!

You can select the cell with the formula, then, in the formula bar use your
mouse to highlight the expressions you want to evaluate then hit function
key F9. There's a limit as to how many array elements it will display,
though. I'm not sure what that limit is but I just tried it on an array of 2
columns by 250 rows and it kicked up a message: Formula too long.

Another option if you use Excel 2002 and up.......

Select the cell with the formula.
Goto Toolsgt;Formula Auditinggt;Evaluate Formula.

This allows you to step through the formula exactly as Excel does. I use
this a lot. It's great for finding problems. One thing, however, at least it
happens to me, if you evaluate certain types of quot;complexquot; array formulas it
causes Excel to crash. I can crash Excel at will!

Biff

quot;Billquot; gt; wrote in message
...
gt; I'm working with the SUMPRODUCT function.
gt;
gt; If I highlight a cell containing a SUMPRODUCT formula, amp; press the formula
gt; (paste
gt; function) key 'fx', it shows me the arrays I've entered. Now, it also
gt; shows me the first
gt; array RESULTS to the right of each formula, like
gt; ={0;0;1;0;0; ... and so on.
gt;
gt; This is very useful. Is there a debug feature, or some way, for me to see
gt; more of the
gt; array results?
gt;
gt; Thanks,
gt;
gt; Bill.
gt;
gt;