Forum Discussion
Anonymous
Feb 24, 2020Using Excel on a Mac from Office 365 internet version
Fyi not real information just practicing !!Was wondering how to add up all my sheets onto one whole sheet..... I have four charts and I am seeking to add the sum of the different totals into one whol...
Anonymous
Feb 25, 2020I have posted some pictures
mathetes
Feb 25, 2020Silver Contributor
The answer that @Matt Mickle provided a few messages ago works just fine. If you enter in cell C4 of your "Consolidated" sheet this formula, and then copy that to the other corresponding cells, you should get your answer.
=SUM(Sheet1:Sheet2!C4)
Change the names of the sheets to correspond to your doctors' names, of course.
Since those are not real data, if you are still having trouble please upload the actual workbook rather than images of it. That way one of us here can put a working solution into place.