Thread: Sum
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Sum

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