I have a financial worksheet with expenses by month and a monthly total for
each month. At the end of each subsequent month there is a cumulative total
of the monthly totals (YTD), I cannot figure out how to get an automatic
formula to populate the correct cells to mimick the previous formulas with
the current cell data to get the correct totals.
--
Donna
EMU Alumni

"Bsgrad02" wrote in message
...
I have a financial worksheet with expenses by month and a monthly total
for
each month. At the end of each subsequent month there is a cumulative
total
of the monthly totals (YTD), I cannot figure out how to get an automatic
formula to populate the correct cells to mimick the previous formulas with
the current cell data to get the correct totals.
--
Donna
EMU Alumni

For the first monty, YTD = current month
For the second and subsequent months, YTD = Current Month + YTD last month.

HTH

Gordon,

I am new to discussion groups. I don't understand how to get to the news:...
info you posted, to find my answer. help?
--
Donna
EMU Alumni


"Gordon" wrote:

"Bsgrad02" wrote in message
...
I have a financial worksheet with expenses by month and a monthly total
for
each month. At the end of each subsequent month there is a cumulative
total
of the monthly totals (YTD), I cannot figure out how to get an automatic
formula to populate the correct cells to mimick the previous formulas with
the current cell data to get the correct totals.
--
Donna
EMU Alumni

For the first monty, YTD = current month
For the second and subsequent months, YTD = Current Month + YTD last month.

HTH

"Bsgrad02" wrote in message
...
Gordon,

I am new to discussion groups. I don't understand how to get to the
news:...
info you posted, to find my answer. help?
--

You've seen the answer in my post! Ignore the line that
or similar,
it's just a message ID....