I currently use a standard monthly profit & loss report which gives the monthly totals and cumulative totals as the year progresses.
I would like to know if there is a way I can produce 'automatic' sums for year to date figures as the year progresses without having to resort to putting totals in manually i.e. say:
A Jan Budget
B Jan Actual
c Feb Budget
D Feb Actual
etc. to
Y Budget YTD (i.e. after March; Jan + Feb + March are automatically summed to Y)
Z Actual YTD (i.e. after March; Jan + Feb + March are automatically summed to Y)
Thanks in advance for any suggestions.
Bookmarks