fourthgen
asked on
Excel formula totalling across multiple worksheets
Hello Experts, I am hoping someone can help with searching for and totalling values over multiple worksheets -
I have an Excel file with multiple worksheets, each of which records jobs undertaken for a company in a given month.
All sheets exept TOTALS are formatted in the same way:
Column A as the date in 25.06.13 format
Column B as description of job
Column C as cost
The companies worked for vary from month to month and as such the number of worksheets, and their names, varies greatly - the only constant from month to month is the TOTALS worksheet.
I already have totals for each company in a given month however would like a breakdown on the TOTALS sheet of costs delivered on each day of that month, across all companies.
Could this be achieved with a formula? Or would it have to be a macro?
Either way could someone suggest any code/formulas which may help?
I have an Excel file with multiple worksheets, each of which records jobs undertaken for a company in a given month.
All sheets exept TOTALS are formatted in the same way:
Column A as the date in 25.06.13 format
Column B as description of job
Column C as cost
The companies worked for vary from month to month and as such the number of worksheets, and their names, varies greatly - the only constant from month to month is the TOTALS worksheet.
I already have totals for each company in a given month however would like a breakdown on the TOTALS sheet of costs delivered on each day of that month, across all companies.
Could this be achieved with a formula? Or would it have to be a macro?
Either way could someone suggest any code/formulas which may help?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
NB_VC - Thanks for the link, I have adapted the formula and it works perfectly!
TOTALS
First
IBM
HP
Microsoft
Apple
Rosetta Stone
Last
The formula… =SUM(First:Last!C2) would sum cell C2 from any worksheets that fall between(and including) the worksheets named First and the worksheet named Last. It could be 5 sheets as indicated above or it could be 50 worksheets. I used the names First and Last but the beginning and ending worksheets name can be anything you want them to be. Just make sure the worksheets you want to sum fall between these two boundaries. A sample file is attached.
Q-28140924.xlsm