Language Selection

English French German Italian Portuguese Spanish

Big Bear's Helpful Hints-Google Docs Spreadsheets

Filed under
Howtos

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.

More in Tux Machines

Bad Saved Games, Fedora Scheduling, and Scribbling

In tonight's Linux news, GamingOnLinux.com poster says "game saves are messing up our drives" - stop it! Phoronix.com is reporting on discussions of changing Fedora release schedule. Jack Germain says Scribbleton creates a personal local wiki to store anything from notes to books and Opera 25 draws near. Read more

Musique for Linux Review – A Minimalistic Player for You and Your Music

Musique is a minimalistic music player for the Linux platform that features a simple and clean interface. It's not like there is a lack of open source music players, so we've decided to see if this one is any good. Read more

CentOS 5.11 Officially Released, Probably the Last One in the Series

As you all know already, CentOS is an Enterprise-class Linux Distribution derived from sources provided by Red Hat. This is the eleventh update for the distribution and probably the last one. It features all the packages from all variants, including Server and Client, and the upstream repositories have been merged into a single one. Red Hat announced less than a month ago the release of their last update for Red Hat Enterprise Linux, 5.11. It stands to reason that CentOS 5.11 will also be the last update in the series. Read more

England's Healthwatch switches to open source CRM

England's Healthwatch organisations are now using CiviCRM, an open source solution for customer relationship management. "Open source affords access to a wide community of developers, which means that the software continues to develop and security updates and bug fixes are regularly rolled out", explains Tim Schofield, the organisation's interim systems manager. Read more