Subtracting cells from another sheets in excel for mac

broken image

Click Sum and put your curser between the two parentheses that show up in your function bar.ģ) Click in the cell you want to add. Here are the steps to sum across multiple worksheets in all three programs:ġ) Click in the cell you want your sum to go.Ģ) Click on the function button. This procedure seemed kind of difficult, so I wanted to know if it would be easier to do it on Excel or Numbers on my Mac – it was. I searched the Internet and found a helpful tutorial. I could not figure out how to sum up the totals for each week, which were on different worksheets, into one cells.

broken image

I really liked using Google Spreadsheets because I could easily format the cell colors into my favorite neon pinks, yellows, and greens. I made a spreadsheet for my hours during this internship using Google Spreadsheets.