How do I sum YTD totals based on monthly totals

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
Click to expand...

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 info you posted, to find my answer. help?
 
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?
--
Click to expand...

You've seen the answer in my post! Ignore the line that
says:or 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

Similar Threads

Access YTD - Form 0
Excel 2003 Sum question 2
copying relative reference across worksheets 2
Excel Getting an annualized figure based on YTD in Excel 1
Totaling cells based on input value 1
Conditional SUM of column values depending on the heading (month) 1
Outlining on a protected spreadsheet 1
YTD Totals 1

Back
Top