I do understand that but I did not explain myself correct before. Let's say
you have data in row 9 that you enter. The totals for that data is totaled in
cell L9,M9,N9. I would like that data to show in L15,M15,N15. But when data
is entered in row 10 and totaled in cells L10,M10,N10 that data will appear
in cells L15,M15,N15.

Hope you can help

"JLatham" wrote:

My thought also. Danny, put your SUM() formula at the top, be careful - you
can't reference the cell itself (circular reference). But lets say the total
is from cells in column C, then in C1 you could put =SUM(C2:C65536) and be
done with it.


"Don Guillett" wrote:

An easy way is to put the sumformula at the top...

--
Don Guillett
SalesAid Software

"danny boahn" wrote in message
...
I am setting up a spread shift that will have a different total everytime
someone adds a new line how can i set the cell up to show that different
total