Big Bear's Helpful Hints-Google Docs Spreadsheets
I like to jot down things that I learn how to do on the spur of the moment so that I can find it later.
I admit, in the 80's there was quite of bit of "herbal remedy" usage and my short term memory isn't what it could be. That's my story and I'm sticking to it.
I've decided that I might as well potentially help some other folks who might want to know about some of the things I discover, so I thought why not here?
For my very first post, I wanted to figure out how to sum cells across multiple pages in Google Docs spreadsheets.
The example I am using is related to a mileage spreadsheet, broken down as one month with 5 sheets , one for each week. "Week 1", Week 2", et al..
on my sheets, the weekly total for mileage and for the ederal assigned value to that mileage is in the same cell on each page. say, "F33"
In cell F36 on sheet 5, I wanted to put the monthly total of all miles from each sheet.
So, in that cell, I typed "=SUM('Week 1'!F33+'Week 2'!F33+'Week 3'!F33+'Week 4'!F33+'Week 5'!F33)"
Which, of course, allows me to have my total.
I did the same for total value on the mileage except for the corresponding cells (say G33). It's the same formula, just replacing "F33" with "G33".
Now I can always come back here to find this info, because I will forget. and maybe it wil lhelp someone else out while it's here.
The post titles will introduce the area that the post relates to, like this one shows "Google".
By the way... I am doing all of these things using Linux Mint Debian Editon. So yes, these are Linux do-able.
- bigbearomaha's blog
- Login or register to post comments
- Printer-friendly version
- 22715 reads
- PDF version
More in Tux Machines
- Highlights
- Front Page
- Latest Headlines
- Archive
- Recent comments
- All-Time Popular Stories
- Hot Topics
- New Members
digiKam 7.7.0 is releasedAfter three months of active maintenance and another bug triage, the digiKam team is proud to present version 7.7.0 of its open source digital photo manager. See below the list of most important features coming with this release. |
Dilution and Misuse of the "Linux" Brand
|
Samsung, Red Hat to Work on Linux Drivers for Future TechThe metaverse is expected to uproot system design as we know it, and Samsung is one of many hardware vendors re-imagining data center infrastructure in preparation for a parallel 3D world. Samsung is working on new memory technologies that provide faster bandwidth inside hardware for data to travel between CPUs, storage and other computing resources. The company also announced it was partnering with Red Hat to ensure these technologies have Linux compatibility. |
today's howtos
|
Recent comments
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago