Forum Discussion
Using 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...
I have posted some pictures
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.