How do I use totals for one page to create a year-to-date total pa

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jlac - 29 Jul 2006 02:23 GMT

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

Reply to this Message

John Vinson - 29 Jul 2006 02:46 GMT

>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
[quoted text clipped - 3 lines]
>
>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]

Reply to this Message