MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Month to date figures and year to date figures


Posted by Cathy on August 15, 2001 11:44 AM

I am trying to create a spread sheet where I can imput daily totals and they will add to the exiting months total, and the exiting year to date total
Example: Monday $10 Month to date $10 Year to date $50
Tuesday $15 Month to date $25 Year to date $65
This spread sheet would NOT show each day. Tuesdays sheet would not show Mondays figures, so I cannot use a formular
like A2 + B1 in column B2.

Any suggestions??????


Posted by Russell Hauf on August 15, 2001 4:50 PM

I'm a little confused...do you have one sheet for each day of the week? You say, "Tuesday's sheet," and "Monday's sheet." If you could give an example of what your data looks like (or what you want it to look like) it would help greatly.

Russell