I am trying to run a fiscal year total as well as a project to date total.
When I put in the formula it works as it should until I go to the cell below
to type in that info and it adds it to the above total. The following is an
example:
A1 B1 C1
Current Month FY to date Project to date
=Sum(A1+B1) =Sum( B1+2648)
When I put this formula in and put an amount in current month it calculates
correctly. When I put an amount in A2 it adds it to B1 and C1. Any
suggestions would be greatly appreciated.