Cumulative Total

J

Jack of all trades

I am trying to create a running total of sales objective achievement. For
example, If in August the objective is 20 and I actually sold 25, then I am
at positive 5. Then in Sept, my objective is 30 and I sold 20, I am now at
negative 5. I do not want the number to change in my monthly column, but I
would like for it to update in my fiscal year column based upon sales for
each month. Is it possible to do this and if so how?
 
R

RagDyer

I don't exactly understand if you want the running total to be alongside the
monthly totals in a separate column.

Labels in row1
Columns
A = Date (Month)
B = Sales
C = Objective
D = YTD Achievement
With this formula in D2:

=SUMPRODUCT($B$2:B2-$C$2:C2)

And drag down to copy

*OR*

Do you want just a single cell containing a single formula that will return
the YTD Achievement:

=SUMPRODUCT(B2:B13-C2:C13)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



message I am trying to create a running total of sales objective achievement. For
example, If in August the objective is 20 and I actually sold 25, then I am
at positive 5. Then in Sept, my objective is 30 and I sold 20, I am now at
negative 5. I do not want the number to change in my monthly column, but I
would like for it to update in my fiscal year column based upon sales for
each month. Is it possible to do this and if so how?
 
Top