Question about cell assignment

  • Thread starter Thread starter neuron
  • Start date Start date
N

neuron

I am making a spreadsheet where I add one new data point to a colum
each day (e.g. number of cars I honked at yesterday)

I also have a box that calculates statistics based on the data entere
(e.g. total number of cars, percent increase over time, etc)

How can I assign a formula in the "statistics box" that will updat
when I enter in the new value in the "data column"? Is there som
general notatation that will tell the cell to search for the mos
recent value in a column of data?

Thanks for your comments
 
One formula would be =Sum(A:A). This will give a running
sum of all data entered in column A.

Charlie O'Neill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top