If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

#1
September 7th 07, 08:56 AM posted to microsoft.public.excel.worksheet.functions
 Belle[_2_] external usenet poster Posts: 8

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
September 7th 07, 11:32 AM posted to microsoft.public.excel.worksheet.functions
 Duke Carey external usenet poster Posts: 1,081

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('Janec'!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
May 13th 09, 04:37 PM posted to microsoft.public.excel.worksheet.functions
 creek533 external usenet poster Posts: 1

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.

--
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('Janec'!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

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Adding multiple data fields from time based data. JMK Excel Discussion (Misc queries) 1 July 27th 07 10:59 PM synchronizing data on multiple spreadsheets Ha-Lee Excel Worksheet Functions 0 January 31st 07 03:33 PM Combining data from multiple worksheets and separate spreadsheets kfletchb Excel Discussion (Misc queries) 1 August 10th 06 07:53 PM How do I link data between multiple excel spreadsheets Scott Excel Discussion (Misc queries) 0 May 8th 06 07:28 PM Merge Data from Multiple Spreadsheets Carm Excel Worksheet Functions 1 February 27th 05 01:43 PM

All times are GMT +1. The time now is 02:11 AM.