Since you say that you intend to input "a lot" of data, heed my caveat
pertaining to the range size for this type of formula.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Bob" wrote in message
...
Could explain this briefly? where does the $ sign come in, and also I'm
looking to input a lot of data and not have to keep copying and changing the
number (ie A$3:A3, A$4:A4), can I apply this to the entire column?
Thanks for your help
Rob

"John C" wrote:

Assuming data starts in row 2, and summing data in column A.

In B2: =SUM(A$2:A2)

Then copy down as needed.

Hope this helps!
--
John C


"Bob" wrote:

Sorry if I've already asked this, having trouble finding old post.
I'm trying to write a program for column B so that every cell will be
the
sum of the cells above it and the cell to the left of it, ie something
like
=sum(B(n-1),An)
but it doesn't recognize n, and I don't even know if you can write a sum
function for an entire row.
Thanks,
Bob