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
