Trace Precedents Function

N

Niggel

I have a sheet with a SUM function that has many precedents (like 50). When
I click "Trace Precedents" some of the precedent cells are not identified by
the
blue dots as they should be. The correct cells are in the formula which
works OK but it is annoying and more time consuming that I can't visually
check the precedents using this function.

Any ideas please?
 
K

Ken Wright

I'm assuming you have ranges within your formulas, as the Trace Precedents will only pick up the
top leftmost cell of any range that exists within your formula, eg:-

=SUM(F7:K7)+SUM(G10:I10)+SUM(I13:K13)

Trace Precedents will only pick up on F7, G10 and I13
 

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

tracing precedents 1
WHAT ARE REASONS THAT A FORMULA WILL NOT RESPOND TO PRECEDENTS? 1
Exact Precedents 8
Trace precedents (Excel XP) 1
Dots on Trace Precedents Arrows 1
How do you ID cell precendents/dependents in other sheets? 2
How to show all precedent arrows on whole worksheet at same time? 1
Office 2007 Trace Precedents + Tables 8

Top