As I understand it, both your formula for summing and the values that you want to sum are in the same column, separated by an empty space (in fact an empty row). Apparently you are inserting a new row after the last value to enter a new value and you are deleting a row to remove a value that the row contains. If this is the right description,the following does what you want:

B1 contains 10, B2 contains 25, and B3 contains 12 (from your example). Then:

Put in B5 the formula

=SUM(INDIRECT(D1))

Put in D1 the formula

=CONCATENATE(ADDRESS(ROW(B1),COLUMN(B1)),":",E1)

and put in E1 the formula

=ADDRESS(ROW(B5)-2,COLUMN(B5))

In all frankness, I have doubts about this kind of convoluted solutions and the problems they solve.

Cheers.

Aladin

Hi Aladin,

Thanks for your reply.

What I was trying to is to have the formular with the total of "74" which is the total of 10+12+25. This formular could be at C1 for example reading something like: =SUM(B1: to the empty space)

I need it to find the empty space because sometimes there are more or less numbers to add up.

Thanks a lot for your help

Walter

You noticed of course that I avoided your construct "to the empty space" in my first reply (which is difficult to compute). I avoid it again in the suggestion below. Hope though that it works for you.

If the column that contains the numbers to be totaled contains no formulas like SUM, AVERAGE, COUNT that return aggregate values which are based the numbers to be totaled, I would suggest using in C1

=SUM(B:B) where B is the column you reserve to hold the numbers you want to sum, etc.

Aladin

Another description is to sum from the 1st number

to the last in a range. If your formula is in the

cell to the left of the range, enter

=sum(Rightarrow CtrlShiftRightarrow).

This covers the contiguous range.

Hi,

As long as column B has nothing in it but

the numbers that you want to add, try this in

a cell in some other column (it's an array formula,

so use control-shift-enter to input it):

=SUM(INDIRECT("B1:B" & MIN(IF(ISBLANK(B1:B10000),ROW(B1:B10000)))))

HTH