Excel Formulas

[Diana]

I am having trouble getting a formula to calculate fy to date and project to
date.
I need the cells to have a running total month to month. I have tried the
following:
Current Month Fy to Date Project to Date
=Sum(A1+B2) =Sum(B2+6248)
This formula will work for that row. But when I input different information
in the next row or use the enter key it adds that amount to cell B2. Any
explanations or help would be greatly appreciated as I have tried every thing
I know.

 

[JE McGimpsey]

I am having trouble getting a formula to calculate fy to date and project to
date.
I need the cells to have a running total month to month. I have tried the
following:
Current Month Fy to Date Project to Date
=Sum(A1+B2) =Sum(B2+6248)
This formula will work for that row. But when I input different information
in the next row or use the enter key it adds that amount to cell B2. Any
explanations or help would be greatly appreciated as I have tried every thing
I know.

It's hard for me to tell exactly what you're trying to do, since I don't
know what cells A1 and B2 represent.

Couple of suggestions:

1) using both SUM() and + isn't necessary - you can use either

=A1 + B2

or

=SUM(A1,B2)

2) If you have something like:

A B C D
1 Month Amount FY To date Project to Date
2 January 100 =B2 =B2+6248
3 February 150

Then one way would be to use

C2: =IF(B3<>"",B3 + C1,"")
D2: =IF(B3<>"",B3 + D1,"")

which you can then copy down as far as necessary.


If that's not what you're doing, post back with more detail.

 

[Diana]

Thanks for the suggestions. This is a spread sheet that keeps track of
safety and safety hours. In one row I need hours next row would be injuries.
This is what the columns are:
A B C
Current Month FY to Date Project to date
(carried year to year)

My project to date is 6248. When I put an amount in Current month I need it
to carry over and add to B and C. When I get it to add correctly, and i
enter amount in the next row under current month it adds it to the first rows
b and c. I need these rows to all be seperate. Any help would be appreciated