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

Google is making encryption standard in the next version of Android

Less than a day after Apple detailed new efforts in user privacy for its products, Google now says it plans to encrypt user data on all Android devices. Speaking to The Washington Post, Google says data encryption will now be a part of the activation process instead of an optional feature. The end result is that whatever data is stored on that device, be it a phone or tablet, will be inaccessible unless the person has the correct password. Read more

Samsung to Launch Tizen based Smartphone in India in November 2014

It looks like a Tizen Smartphone launch in India is on the cards, and the launch date is November 2014 for our Linux based friend. Samsung believe that they can use content to differentiate themselves from the competition, enabling them to maintain their lead in the Indian Smartphone market. We are not expecting the launch of the Samsung Z at this point, but more likely the budget Tizen Samsung SM-Z130E or SM-Z130H. Read more

NVIDIA 343.22 Linux Driver Brings Support for GTX 970 and GTX 980

NVIDIA has released a new Linux driver for its products and the developers have added support for the latest GPUs that were just announced. Read more

Linus Torvalds and others on Linux's systemd

If you're not a Linux or Unix developer, you've never heard of systemd, the new Linux-specific system and service manager. In Linux developer circles, however, nothing else ticks off many programmers more than this replacement for the Unix and Linux's traditional sysvinit daemon... Read more