 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / January 2007Excel Formulas
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. > I am having trouble getting a formula to calculate fy to date and project to > date. [quoted text clipped - 6 lines] > 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. 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 > > I am having trouble getting a formula to calculate fy to date and project to > > date. [quoted text clipped - 35 lines] > > If that's not what you're doing, post back with more detail. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.