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

4MLinux 20.1 released.

This is a minor maintenance release in the 4MLinux STABLE channel. The release ships with the Linux kernel 4.4.34, which restores PAE support that "magically" disappeared in 4MLinux 20.0 (sorry :-). Additionally, some popular programs (Double Commander, Dropbox, Firefox, Java RE, Opera, PeaZip, Thunderbird, Wine) have been updated, too. Read more

Refracta 8.0 Is a Pint-Sized Powerhouse

Refracta is a somewhat obscure Linux distribution that offers exceptional functionality and stability. Obscurity is not always a bad thing when it comes to Linux distros. You can find some very worthwhile alternatives to your current operating system. Refracta is a big surprise in a small package. Many look-alike desktop distros are difficult to distinguish from run-of-the-mill garden varieties. Others offer new adopters something unique that makes using them fun and productive. Refracta is one of the few full-service Linux distros that makes an easy and more convenient replacement for pocket Linux options such as Puppy Linux. Not all Linux distros that install to a USB drive -- and have the ability to save files and system settings in a persistent mode -- work equally well. Read more

Clear Linux With Mesa 13 Is A Strong Match For Intel Linux Performance

When benchmarking Intel's Clear Linux distribution earlier this year we found its Intel graphics performance to be quite good and slightly faster than other Linux distributions even when Clear was using an older version of Mesa. Now with Clear Linux having switched to Mesa 13, I decided to run some fresh Intel OpenGL benchmarks on it compared to other distributions. Read more

PTS: PHP 7.1 vs. PHP 7.0 vs. HHVM Benchmarks

With today's PHP 7.1 release, performance isn't highlighted as much as language improvements to this first major update to PHP7, but I decided to run some PHP 7.1, PHP 7.0, PHP 5.6, PHP 5.5, and HHVM benchmarks of our open-source Phoronix Test Suite code-base. These self-tests of the Phoronix Test Suite aren't the conventional PHP workload of just a CMS, blog, or other web application that can be cached, etc, but effectively of a PHP CLI application. So keep this in mind when looking at the results and that your mileage may vary depending upon use-case. Read more