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

Why Linux Installers Need to Add Security Features

Twelve years ago, Linux distributions were struggling to make installation simple. Led by Ubuntu and Fedora, they long ago achieved that goal. Now, with the growing concerns over security, they need to reverse directions slightly, and make basic security options prominently available in their installers rather than options that users can add manually later. At the best of times, of course, convincing users to come anywhere near security features is difficult. Too many users are reluctant even to add features as simple as unprivileged user accounts or passwords, apparently preferring the convenience of the moment to reducing the risk of an intrusion that will require reinstallation, or a consultation with a computer expert at eighty dollars an hour. Read more

Linus Torvalds Announces Subsurface 4.6 Open-Source Dive Log and Planning App

Linus Torvalds not only works on the Linux kernel, but he's also part of the development team behind the open-source dive log and dive planning application most of you out there know as Subsurface. Read more

openSUSE Tumbleweed Gets XOrg Server 1.19 & Irssi 1.0, PulseAudio 10 Coming Soon

openSUSE Project's Douglas DeMaio is informing the Tumbleweed community today, January 18, 2017, about the latest software updates and other improvements delivered by a total of two snapshots released last week. Read more

today's leftovers

  • Linux use on Pornhub surged 14% in 2016
    Pornhub is one of the preeminent porn sites on the web. Each year Pornhub releases a year in review post with anonymous details about the site’s users. More and more Linux users are visiting Pornhub, Linux saw an impressive 14% increase in traffic share in 2016.
  • Amdocs partners with Linux Foundation to accelerate OpenECOMP adoption in Open Source
  • Calamares 2.4.6 Distribution-Independent Linux Installer Delivers Improvements
    The Calamares team is proud to announce the availability of the sixth maintenance update to the 2.4 stable series of the open-source, distribution-independent system installer Calamares, for Linux-based operating systems. Calamares 2.4.6 comes approximately two months after the release of the previous version, namely Calamares 2.4.5, and, as expected, it's a bugfix release that only delivers various improvements and bug fixes for some of the issues reported by users during all this time.
  • Shotwell Photo Manager 0.25.3 Released
    Photography fans will be pleased to hear that a new bug-fix release of photo management app Shotwell is now available to download.
  • AntiX 16.1 is available for public
    AntiX is Debian based Linux distribution. It uses lightweight desktop environments like Fluxbox, Icewm, Xfce, etc. This distribution is originated in Greece and is typically ideal for old systems. Few hours ago AntiX team released new version named AntiX 16.1. It is based on Debian Jessie.
  • Tumbleweed Preps for PulseAudio 10, Gets Ruby, Python Updates
    Developers using openSUSE Tumbleweed are always getting the newest packages as well as updated languages and past week’s snapshots delivered update versions of Python and Ruby. The most recent snapshot, 20170112, brought Python 2.x users version 2.7.13, which updated cipher lists for openSSL wrapper and supports versions equal to or greater than OpenSSL 1.1.0. Python-unidecode 0.04.20 was also updated in the snapshot. Another update related to OpenSSL 1.1.0 was PulseAudio 9.99.1, which is a release in preparation for PulseAudio 10.0. PulseAudio 10.0 includes compatibility with OpenSSL 1.1.0, a fix for hotplugged USB surround sound cards and and automatic switching of Bluetooth profile when using VoIP applications.
  • Genode OS Framework Planning For Async I/O, App ABI, Qt5 Plans For 2017
    The Genode Operating System Framework has announced their planned roadmap for this year as the involved developers continue working on this original OS initiative. The overall theme of the Genode OS work in 2017 is to focus on stability and scalability, but there is also much more on their road-map for this calendar year.
  • PrestaShop
    Helping people overcome the challenges of building and growing an online business is what the PrestaShop open-source ecommerce platform is all about. The significant PrestaShop 1.7 release provides innovations focused on three themes: sell faster, create easier and code better.
  • This Week in Spring: Reactor 3.0, Open Source CD, and All Kinds of Cloud