How do I sum YTD totals based on monthly totals

B

Bsgrad02

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.
Click to expand...

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

HTH
 
B

Bsgrad02

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?
--
Click to expand...

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