By Chantal Bolduc at July 13 2019 06:29:58
Creating a Sum across worksheets. This is also an inter_active link. If a number changes on one worksheet, the sheet with the summary formula will also be updated. If a worksheet is inserted between worksheets in the sum, the sum will automatically be updated. Some of the disadvantages of this method are that all of the linked cells must be in the same location on all worksheets. Also, you can only sum one cell at a time (although you can copy the formula to other cells in the summary worksheet.) Using group mode to create identical spreadsheets will help when using the sum function across worksheets. This method is also limited to within a workbook and cannot be done across workbooks.
Know the author's background. This person needs to have a background in education and, ideally, should be trained in the latest educational methods, like brain_based teaching/learning. I personally would never use any materials with my child that didn't specifically mention being "brain_based." I am not talking about just "research_based." I see more and more sites claiming to have research_based materials, but what I find is definitely NOT based on how the brains actually learns. Brain_based learning is relatively new in the educational world, but most worksheet sites and materials are using old science or, more often, no science at all.