look up cells to sum - excel

[VilMarci]

Dear Group,

I have a big issue.
Here's the situation:
I have some numbers in a column:

123
465
782
134
....
lot of numbers....

And a few sums: 1313ó, 6464...

I have to find out where those sums are coming from. They should be sums of
the numbers in that column.
To make things harder I do not know how many numbers shall I add together.

Please advise how to write a fuction that helps me out. I know vba but this
looks a bit over my skills.

Many thanks,
Marton

 

[Gary''s Student]

How many numbers in the column?

 

[VilMarci]

Hello,

A lot and it differs every time.
Any ideas?

Marton

 

[AMDRIT]

Look into the Precedents property of a given range.

if instr(range("A1").formula,"=Sum")>0 then
for each rng in range("A1").precedents
debug.pring rng.addres
next rng
end if

HTH

 

[VilMarci]

Hm... This is not clear.
I do not have a Sum function on the sheet.
I have exact, static numbers.

like:

1
2
3
-4

and I have an other number:

2

I need to know that this can come like:

2
3 +2 +1 +(-4)

Marton