The formulas should automatically update as you add values (assuming
Calculation mode is set to Automatic).

Alternative approach:
You could set up your months to collect values from an 'Amount' column
by date if you record dates for each revenue transaction. This is how
my bookkeeping app works, so transaction entries can be input at random
and each month column only collects entries for their respective month.

YTD is done on a 'Summary' sheet that's set up like a P&L so it shows
revenue, COGS, and Expenses by month. Totals are by month, quarter, and
YTD. This sheet collects values from 'Income' and 'Expenses', and so is
read only. YTD is by row for each section. Detail is handled via
Outlining for each Expense category, where sub categories display their
respective amounts. Detail for the Revenue sub categories are handled
the same way, though there's only one revenue category.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion