I need summarise months into years, how can i do that?

Posted by Tay on Stack Overflow See other posts from Stack Overflow or by Tay
Published on 2009-06-29T20:02:58Z Indexed on 2010/04/20 5:03 UTC
Read the original article Hit count: 196

Filed under:

spreadsheets

Hi i working a fairly large spreadsheet which is broken down into months. I want to put the yearly subtotals at the begining of the spreadsheet. So in cell A1 i want to add AA2-AL2, B1 i want to add AM2-AX2 and so on so forth. How can i do this whithout manually going to each set of values.

Is there anyway i can put a formula in A1 which i can copy to B1,C1,D1,E1, which will pick up a set of 12 cells each (with no overlap)

Related posts about spreadsheets

does google spreadsheets create forms?

as seen on Super User - Search for 'Super User'
after going to this URL: link text i noticed that it is powered by google docs. i didnt know that google docs make online forms as well. does google doc provide the option to make online forms? has anyone had experience doing this? what language are they using to make this thing so scalable? >>> More
Creating Excel or Excel compatible Spreadsheets on the server side in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format. I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed. For this web project I'm building, the server doesn't have office installed… >>> More
Rapid Planning: Next Generation MRP

as seen on Oracle Blogs - Search for 'Oracle Blogs'
MRP has been a mainstay of manufacturing systems for 40 years. MRP evolved from simple inventory planning systems to become the heart of the MRPII systems which eventually became ERP. While the applications surrounding it have become broader, more sophisticated and web-based, MRP continues to operate… >>> More
Excel - Linking multiple source spreadsheets with variable amounts of rows to a destination spreadsh

as seen on Super User - Search for 'Super User'
I have multiple source spreadsheets, each with a variable number of rows. An example might be one spreadsheet per bank account, with one row for each transaction, with a date and amount. One spreadsheet might have 30 rows, the other 50, and so on. I want to create another spreadsheet which links… >>> More
Access / Excel crossover: Should i attach spreadsheets to records

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I currently have an archaic system of client records that I am trying to improve. For each client i have a directory, in that directory i include a directory for each job. Each job has a spreadsheet that i use to store their personal details, and run calculations and costings specific to their… >>> More

Developer IT

I need summarise months into years, how can i do that? - Developer IT

I need summarise months into years, how can i do that?

spreadsheets

Related posts about spreadsheets

does google spreadsheets create forms?

Creating Excel or Excel compatible Spreadsheets on the server side in C#

Rapid Planning: Next Generation MRP

Excel - Linking multiple source spreadsheets with variable amounts of rows to a destination spreadsh

Access / Excel crossover: Should i attach spreadsheets to records

Categories cloud