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 whole total on one sheet. There is no consolidated option .. Maybe ill have to resort to using my school computer with the actual app on it...
8 Replies
Deleted
If you have multiple sheets you can sum them all like this...
For Example: Sheet1,Sheet2,Sheet3 & Summary (The worksheet to consolidate the other worksheets)
You can use a simple formula like this to sum A1 from Sheet1,Sheet2 & Sheet3
=SUM(Sheet1:Sheet3!A1)This will also work if you have other sheets named in this numeric fashion...for example if your worksheets were labeled Data1,Data2 & Data3 you would use a formula like this:
=SUM(Data1:Data3!A1)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
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.
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
