Getting a cell to update totals automatically every day

  • Thread starter Thread starter drmcleod
  • Start date Start date
D

drmcleod

I have column A for every day of the year .

In column B I enter in a value for each day of the year.

How do I make a separate cell add up the total value of Column B
automatically each day without totaling the whole year?

For example, I have =SUM(c4:360) but this totals for the entire list. How
do I get excell to automatically increase one cell/day i.e. from =SUM(c4:c5)
to =SUM(c4:c6) etc, etc, etc?
 
hi
Try it this way : =SUM($C$4:$C5)
Take notice only the 5 dos't have a $
You can drag this down and only the 5 will change to 6 and 7 etc,etc
HTH
John
 
If you want the up-date total of all the B cells the formula is
=SUM(B1:B365)
True this will include the empty cells after the current date, but this will
be treated as zeros

If you want a running total for each day: In C1 enter =SUM($C$1:C1)
Copy this down the column; in C2 it will read =SUM($C$1:C2)

The quickest way to copy the formula in C1 is to double click its fill
handle - the small solid square in the lower right corner of the active cell

best wishes
 
Hi

One way
=SUM(B1:INDEX(B:B,DAY(TODAY())))

However, if the data in column B has not been entered beyond today, then you
would get the same result with
=SUM(B1:B365)
 
Back
Top