Menu

adding values across worksheets in a spreadsheet

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Andy Brown

Posts: n/a

Default

"ed java" <ed wrote in message
...
I have a spreadsheet with monthly worksheets. Is there a way to add up
the
values of the same cell from each month at the end of the year to get a
yearly total?

Assuming they're in order, try something like:

=SUM(Jan:Mar!A1)

HTH,
Andy

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I reference values from 200 worksheets onto a summary sheet	mac849	Excel Discussion (Misc queries)	4	March 17th 05 09:26 AM
Adding rows of different info from separate worksheets into summar	Barry P	New Users to Excel	1	February 8th 05 02:47 PM
How to sum values in multiple worksheets	Robert Lawrence	Excel Worksheet Functions	3	January 29th 05 05:15 AM
I need to have only the values show in a spreadsheet.	Debutante	Excel Worksheet Functions	1	January 21st 05 06:59 PM
Help adding text values	Texas-DC_271	Excel Worksheet Functions	7	January 15th 05 11:14 PM

All times are GMT +1. The time now is 07:06 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement