I cannot figure out exactly why or what you mean.
I know autofill could come up with a range itself when you place the
function below a list of data. It will then count all the numbers above
it.

Try the following:

Go to the cell you want the SUM to be.
Left mouseclick.
Then topmenu
insert function Mathematical SUM and OK
<look what happens now: it will show a range automatically
click red arrow
select range (J5:J6) with your mouse in the sheet
enter
ok

You this out at J7 and again at J9.
See what happens.

You can always see the function and range in the top of your screen
just below the menu's.

Be aware that if you copy this cell with function to another cell it
will change the range.
Use relative indexing =SUM($J$5:$J$6) if you do not want this to
happen.


--
pvanrooijen
------------------------------------------------------------------------
pvanrooijen's Profile: http://www.excelforum.com/member.php...o&userid=26090
View this thread: http://www.excelforum.com/showthread...hreadid=565736