Forum Discussion
Using Excel on a Mac from Office 365 internet version
Deleted
Is it possible to upload the sheets you're talking about? And maybe give a bit more of an explanation of the difficulty. From your very brief description, it sounds as if it should be straight forward.
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.
Deleted FYI this is just practice this isn't actual information !!
From c4 to i23 I have data on four different sheets the same lay out on each BUT different numbers on each sheet like example different amounts of people so the numbers are different but same title .From each sheet I need to take from each sheet and put it onto one whole sheet for the total from the different pages . I don't know if I have to do it by row or column and the sum= doesn't work the pages are renamed different then sheet 1 sheet 2 mathetes