Grahamfff Posted December 21, 2006 Share Posted December 21, 2006 I have some accounts in an Excel file. I have set up a worksheet for each month, Jan - Dec, and a thirteenth worksheet to give the totals for the year. So, in cell A10 on the Totals worksheet, I want a formula totaling the contents of cell A10 for all of the worksheets Jan - Dec. Is there an easier way that either typing =Jan!A10+Feb!A10... and so on? Or keying = and then going to each worksheet in turn to click on the A10 cell? As the accounts are quite complex, I'd ideally like to build the totals worksheet by using fill right / fill down as much as possible. Any help gratefully received! Link to comment Share on other sites More sharing options...
Strix Posted December 21, 2006 Share Posted December 21, 2006 you can't use the click and drag method to achieve this then? Link to comment Share on other sites More sharing options...
Kristian Posted December 21, 2006 Share Posted December 21, 2006 That's a really easy thing to show someone, but a really difficult thing to articulate on here. I'll have a look to see if I can find anything suitable on-line. Link to comment Share on other sites More sharing options...
Mr Goose Posted December 21, 2006 Share Posted December 21, 2006 click and highlight the column/row, go a couple of cells beyond then click autosum... As posted tho - really easy to show visually, less easy to write. Try googlling for a "Guide to Excel" pdf.. Link to comment Share on other sites More sharing options...
Grahamfff Posted December 21, 2006 Author Share Posted December 21, 2006 click and highlight the column/row, go a couple of cells beyond then click autosum... As posted tho - really easy to show visually, less easy to write. Try googlling for a "Guide to Excel" pdf.. Unless I'm missing something, this method won't gather the figures I intend from other worksheeets? Link to comment Share on other sites More sharing options...
Tricky Posted December 21, 2006 Share Posted December 21, 2006 =sum(jan:dec!A1) Link to comment Share on other sites More sharing options...
Grahamfff Posted December 21, 2006 Author Share Posted December 21, 2006 =sum(jan:dec!A1) Brilliant! Thank you! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.