Tracing cells

N

nova422000

Joined
Nov 9, 2006
Messages
1
Reaction score
0
If I have A1:A1000 and I know that A1000 is the sum of 3 unknown cells up there, how to I write the function to trace which 3 cells add up to A1000?

Thanks.
 
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

Excel Need Countifs Formula Help 0
Help with SUMPRODUCT & converting date to value 1
Calculate average in intervals 1
Conditional Formatting - Comparing 2 columns 1
sumif wildcard criteria 1
Delete rows based on contents of Col A 0
concatenate a range function 7
search for a particular string in cells 3

Back
Top