View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Diana Diana is offline
external usenet poster
 
Posts: 61
Default Help with Formula

I am trying to get a formula to work that when I put a number in Current
Month it will add to FY to Date and Project to Date. The FY and Project to
date totals need to be a running total. I have tried the following: in cell
B1 =A1+B1 and in cell C1 =A1+6248. This calculates in row 1, but when I
input into row two or hit the enter key the total in column b and c
increases? Any help would be greatly appreciated.

A B
C
CURRENT MONTH FY TO DATE PROJECT TO DATE
Emp hours
injuries
fatalaties