Forum Discussion
Using Excel on a Mac from Office 365 internet version
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)
- DeletedFeb 25, 2020
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