Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Data from Multiple Spreadsheets
I have createda spreadsheet which includes separate workbooks with figures
for each month of the year, I have also created a workbook within this spreadsheet which is for the yearly figures but i cant seem to figure out how to create the right formula to add the data from the monthly spreadsheets onto the yerly spreadsheet. This is in Office 2007 on windows vista. Can any one help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Data from Multiple Spreadsheets
Belle -
First, an FYI: An Excel file is called a workbook. Within each workbook are tabbed pages that can be worksheets or charts. Your post seems to confuse workbook with worksheet. If I understand your question correctly, you have a WORKBOOK that contains WORKSHEETS (or sheets, for short) for each month and another sheet for the annual totals. You want to add the values in the monthly sheets to get the annual totals. Let's say the annual sheet is the left-most tab, that Jan-Dec are in order to the right, that each sheet is named with the 3 letter month abbreviation, and you want to add the values in cell B2 on all the monthly sheets. Use this formula: =sum('Jan:Dec'!B2) "Belle" wrote: I have createda spreadsheet which includes separate workbooks with figures for each month of the year, I have also created a workbook within this spreadsheet which is for the yearly figures but i cant seem to figure out how to create the right formula to add the data from the monthly spreadsheets onto the yerly spreadsheet. This is in Office 2007 on windows vista. Can any one help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Data from Multiple Spreadsheets
I've got one step further that I need help with...
I have spreadsheets named Jan1, Jan2, Jan3, etc. - 10 for each month, separated by quarters (therefore, Jan1-Mar30). Data entered into these spreadsheets is entered as an X. So, hopefully to clarify, if cell J18 contains the letter X in any or all spreadsheets from Jan1-Mar10, I need the total to add on the quarterly sheet. Hopefully that made sense? Hopefully enough for someone to help me? It seems so simple and I feel like it's RIGHT there, but I just can't grasp it. Thanks in advance! -- creek533 "Duke Carey" wrote: Belle - First, an FYI: An Excel file is called a workbook. Within each workbook are tabbed pages that can be worksheets or charts. Your post seems to confuse workbook with worksheet. If I understand your question correctly, you have a WORKBOOK that contains WORKSHEETS (or sheets, for short) for each month and another sheet for the annual totals. You want to add the values in the monthly sheets to get the annual totals. Let's say the annual sheet is the left-most tab, that Jan-Dec are in order to the right, that each sheet is named with the 3 letter month abbreviation, and you want to add the values in cell B2 on all the monthly sheets. Use this formula: =sum('Jan:Dec'!B2) "Belle" wrote: I have createda spreadsheet which includes separate workbooks with figures for each month of the year, I have also created a workbook within this spreadsheet which is for the yearly figures but i cant seem to figure out how to create the right formula to add the data from the monthly spreadsheets onto the yerly spreadsheet. This is in Office 2007 on windows vista. Can any one help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding multiple data fields from time based data. | Excel Discussion (Misc queries) | |||
synchronizing data on multiple spreadsheets | Excel Worksheet Functions | |||
Combining data from multiple worksheets and separate spreadsheets | Excel Discussion (Misc queries) | |||
How do I link data between multiple excel spreadsheets | Excel Discussion (Misc queries) | |||
Merge Data from Multiple Spreadsheets | Excel Worksheet Functions |