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

MX Linux is Now Available for Raspberry Pi [Download and Install Guide]

The lightweight and popular Linux distribution - MX Linux extended its reach. And MX Linux is now available for Raspberry Pi devices as a Beta image (Fluxbox-RaspberryPi Respin “Ragout” ) which you can try out on your devices right now. Here's how. Read more

Android Leftovers

Essential Utilities: Flash OS Images

Linux offers a gamut of open source small utilities that perform functions ranging from the mundane to the wonderful. In our eyes, it’s the breadth of these tools that help to make Linux a compelling operating system. For beginners to Linux the range of distributions can be daunting. Should I investigate Ubuntu, Arch Linux, openSUSE, elementaryOS, or even try Solus? A good way to experiment with Linux distributions and find the one that best fits your needs is to create a bootable SD card or USB drive flashed with the Linux distros. The tools featured in this article make this process simple and safe. They are all easy to use with a simple interface, and hard drive friendly. Read more

Stable Kernels: 5.10.10, 5.4.92, 4.19.170, 4.14.217, 4.9.253 , and 4.4.253

I'm announcing the release of the 5.10.10 kernel.

All users of the 5.10 kernel series must upgrade.

The updated 5.10.y git tree can be found at:
	git://git.kernel.org/pub/scm/linux/kernel/git/stable/linux-stable.git linux-5.10.y
and can be browsed at the normal kernel.org git web browser:
	https://git.kernel.org/?p=linux/kernel/git/stable/linux-s...

thanks,

greg k-h
Read more Also: Linux 5.4.92 Linux 4.19.170 Linux 4.14.217 Linux 4.9.253 Linux 4.4.253