98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Sums using multiple worksheets
Sums using multiple worksheets
Resolved · Urgent Priority · Version 2003
Liz has attended:
SharePoint course
Sums using multiple worksheets
Hello
If I have a workbook in which the same format is repeated on many worksheets, have do I tell excel to create a summary page, e.g. add the contents of cell A1 on all the worksheets and place it in A1 on the summary page.
Some of the functions are simple addition.
Others will need to count the number of Yesses and Noes.
Please send idiot's guide, thank you
RE: sums using multiple worksheets
Hi Liz
On your summary page click in the first cell and begin your formula with
=sum(
click on the first cell on the first sheet containing data
put your finger on shift
click on the same cell in the last sheet containing data
type the close bracket
)
and press enter
Excel should now create a sum function that sums the values in the cell spanning the sheets in your workbook .
I hope this helps - let us know if you have any further questions.
Kind regards,
Andrew
Kind regards,
Andrew
RE: sums using multiple worksheets
Thanks, thats great for the additions.
I've been trying to do the same but using COUNTIF (to tot up how many "Y" there are for example). Not got it right yet, please help
Liz
RE: sums using multiple worksheets
Hi Liz
You'll find that not all functions support this feature but COUNT (which counts the number of cells with a numeric value) and COUNTA (which counts the number of non blank cells) might get the answer you are looking for.
Kind regards,
Andrew
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hiding a worksheet in ExcelWant to circulate an Excel workbook file but keep certain worksheets hidden from your colleagues' view? |