How do I sum YTD totals based on monthly totals

G

Guest

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.
 
G

Gordon

Bsgrad02 said:
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.

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

HTH
 
G

Guest

Gordon,

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

Gordon

Bsgrad02 said:
Gordon,

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top