How do I use totals for one page to create a year-to-date total pa jlac 29.07.2006 01:23:01 I created a simple spreadsheet with a page for each month, and a page to show a running total (year-to-date). How do I get the total for each field, in each page and add them up to create a running total in the year-to-date total. The only formulas that I'm using in the other pages is the SUM for each column. thanks lac

Re: How do I use totals for one page to create a year-to-date total pa John Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 29.07.2006 01:46:04 On Fri, 28 Jul 2006 18:23:01 -0700, jlac <jlac[ at ]discussions.microsoft.com> wrote: [Quoted Text] >I created a simple spreadsheet with a page for each month, and a page to show >a running total (year-to-date). How do I get the total for each field, in >each page and add them up to create a running total in the year-to-date >total. The only formulas that I'm using in the other pages is the SUM for >each column. > >thanks lac It sounds like you're doing this in Excel (though in fact Access, the subject of this newsgroup, might be a better choice if you're willing to invest the time and effort to learn it). If you are using Excel, I'd suggest you repost your question in an Excel newsgroup. Scroll down the list of subject areas on the webpage and find one for Excel. This can be done pretty easily in a Report if the information is in an Access table (or even a link to an Excel spreadsheet). John W. Vinson[MVP]