sum across sheets

Hi, I have been frantically trying different methods and searching for help for a while to complete this, but unable to find a solution that allows you to combine sheets if column headers do not remain constant. I need a macro that will produce a summary sheet combining an initial despatch log...

I have a workbook that contains 53 sheets (one for every week of the year and a Totals sheet) where I am downloading production data each week by operator and want to keep a running total in my totals sheet. There are a varying number of operators each week. I want to look for an operator and...

Hi folks, I am putting together an Exit Interview workbook and need a lot of help. I have a summary tab which should total the same cells across multiple exit interview worksheets, as they are added. I have one Exit Worksheet 1 tab, and more will be added as needed. I have a macro button at...

Hi all, I hope you can help me with what I would like to do. I've searched and searched and not come up with anything yet!! I have one sheet which is my 'data' sheet with a number of columns according to date. And I have another sheet which is the chart sheet. I want to populate the chart...

I am trying to build a macro to make some calculations from Sheet 2 and paste the values into Sheet one The button I have runs the macro from Sheet 1 Sub MonthlyMacro() Sheets("Sheet 1").Range("M6") = "=SUM(Sheet 2!U:U)" End Sub

I know I can use an indirect formula to sum across sheets in the same workbook, but is there a way to sum across workbooks, using the same tab name and same cell?

Hi All -- I've run across something I can use your help with. I know the formula to add the same cell across multiple contiguous sheets is: =SUM('Sheet1:Sheet5'!B5) which addes the value in B5 across all sheets between 1 and 5 I'd like to be able to have the user select the 1st sheet in the...

Following up on a similar post regarding summing scores across multiple sheets, I need to modify the formula that Aladin was so kind to provide to fit a different summary sheet. This time I need to split out the different skill levels within a category. Aladin used a way to concatenate the...

Hi, I have two sheets in a workbook. Sheet1 includes information on average monthly pocket money of students from different schools. Sheet1: <tbody> Month School1 School2 School3 School4 Jan 100 125 125 100 Feb 125 100 75 125 Mar 75 150 100 75 Apr 100 100 125 100 May 90 125 100 125...

Hi all, Hopefully there is an easy fix for this! I 'upgraded' to Excel 2013 today and I have noticed that when I am doing a SUM or SUMIF etc in one sheet or workbook where the array is in a different tab or workbook, Excel no longer highlights the cells I am selecting, so it is relatively...

Hi I am pulling my hair out with this. I am sure there is a simple answer. I am trying to sum cell AM4 across multiple worksheets labelled months APRIL-MARCH (financial year). The Cell AM4 in each worksheet currently has the following formula =SUM(AD4,U4,L4,C4) (yes i selected the cells...

I used Excel to figure the payroll commission that we pay our salespeople. I have an individual worksheet for each person that totals in the same manner for everyone. At the end, I have a page that totals all of the individual totals. We use a "draw system" for paying our employees, which...

Does anyone know if it is possible to link into a cell the sum of a line of figures? I was trying to press an "=" into the cell that I want the answer in, and then highlight the row I need the sum of (which is on a different sheet) It is returning with a 0 value every time, even though there are...

I have a workbook with data in 84 separate sheets, all of which have the same format. The data sheets represent different projects. The data I am interested in, a type of expenditure, is in column D, rows 22 – 61 of the sheets. The corresponding row in column B contains an identifier which...

Looking for a way to create a 12-month rolling total in which the totals are not only in the current worksheet but from other worksheets. The worksheets are setup identical and the tab names have a name and year (i.e., AS0904-2012). Each worksheet represents a calendar year. The totals are in...

I am in need of a formula that can sum ranges across worksheets with more than one criteria. The following works but looking for a way to simplify: =SUMPRODUCT(--('Jan 2012'!$B$9:$B$55=K$8),--('Jan 2012'!$C$9:$C$55=D$16),'Jan 2012'!$H$9:$H$55)+SUMPRODUCT(--('Feb 2012'!$B$9:$B$55=K$8),--('Feb...

So far, I have been able to create formulas to track $ by employee and total by contract; however, tracking unbilled hours (my final goal) has proven to be a challenge. The first two summaries draw the information from one worksheet; whereas, the unbilled data come from many (eventually 48...

I'm trying to write a formula to sum numbers from different sheets. The formula will be used to total values from different report sheets, but the last report number is not known. I have already set up macro to rename each sheet "REPORT X" where X is the number of the report. On the totals...

Hello, I am using XL07 and trying to add up totals from several expense reports in one worksheet summary. Each expense report is a separate file. Cells A14 - A27 are the expense description, like Airfare, breakfast, lunch, etc. Cells I14 - I27 are the totals for each row. Example of the...

<TABLE width="100%"><TBODY><TR><TD> I have a spreadsheet that has multiple rows for the same date (Col A), each with different product data in cols B-M. I need to be able to read through each row until the date changes (the number of rows changes each day). Whilst the date matches I need to add...