Forumla Help!!!

  • Thread starter Thread starter Alta
  • Start date Start date
A

Alta

Hello,

I am in need of help with a formula in Excel. I am trying
to create a worksheet for work that would automatically
accumulate a monthly total. The work sheet has a column
for today's figures and the month to date figures. Is
there anyway to continually add the today's figures to the
month to date figures without have to do the math
yourself.

It would be like:

Today's: Month to date:
509.23 1325.18

And if you add the next days total it would automatically
add to the month to date.

Today's: Month to date:
500.21 1825.39

Thank you very much,
Alta
 
Hi

There are a few ways of doing this.
One is to put =A3+B2 in as your month-to-date total. This will add the
previous month-to-date total to your newly entered daily figure.
Another way is to use
=SUM(A$2:A2) in B2
as your month-to-date total. When you fill this down, it will automatically
add from A2 down to the last entry.
 
Thank you for your help but I have a few more questions.

So the cells I am trying to change are cells c14 and e14.
I try to put e14+c14 in the e cell and everytime I enter
another number in a box on the sheet it adds to cell e14.
Is there some setting I have wrong or am I just a hopeless
cause? It does total how I want to.

c14 merged with d14 e14
daily total month to date total
506.09 15,643.88
 
Send me your sheet and I'll take a look.
My address is
(e-mail address removed) but without the 999
 
Alta,

One way to do this is to create a named range for the today's column and
use that in your formula. In your "month to date" column you would
have a formula like this

=sum(today)

consult the help file for more info about working with named ranges.

-R
 
Back
Top