Thread: Sum from top
View Single Post
  #5   Report Post  
 
Posts: n/a
Default

kelmonster wrote:
Does anyone know how I can set up a sum feature from the top row and have it
calculate all the numbers in the column as I enter them without have to
highlight the entire col. when I enter =SUM(...)?


Put =SUM(A:A) into B1, for example.

One problem: you will not see B1 after you
enter so many values in column A that row 1
rolls off the top.