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

Wine 2.0

  • Wine Announcement
    The Wine team is proud to announce that the stable release Wine 2.0 is now available.
  • Wine 2.0 is now officially available
    I just got the announce email from the Wine team that Wine 2.0 is now officially available. It's an absolutely massive release! For those sticking with development builds, you obviously won't really see a difference, but for those sticking to stable releases it's huge.
  • Wine 2.0 Makes Its Debut
    Wine 2.0 is now officially available. Wine 2.0 is the first release from WineHQ under their new time-based (annual) release cadence, following the Wine 1.9 development series. Wine 2.0 has many new features including GStreamer 1.0 support, Direct3D 9/11 improvements, X11 improvements, Direct2D enhancements, better support for many different Windows games, support for Microsoft Office 2013, and thousands of other changes in total.
  • Wine 2.0 Released, Supports Microsoft Office 2013
    A brand new stable release of Wine, the Windows compatibility programme, is now available to download. Wine 2.0 — yes, 2.0 — follows more than a year of development effort and marks the start of a new timed-based release cadence.

BlankOn Linux explained

Hi guys, welcome to the 15th segment of "Introduction with Linux Distro". We have made quite a few introductions from the start of this website, every segment has something unique to itself. So this time we will be having a Linux distribution which have pure philosophy and creativity, as our guest. Let's get to know more about BlankOn Linux. Read more

today's leftovers

FOSS in the European Union

  • Competition authorities first to implement DMS services
    The DRS are published as open source software using the European Union’s open source software licence EUPL, and are available on Joinup. The software provides connectors for most commonly-used document management systems, and includes scripts to create a database to implement the connecting web services.
  • Czech Republic is at the forefront of an open data international project
    With the beginning of the new year, an international project “Open crowdsourcing data related to the quality of service of high-speed Internet” was launched, which aims to encourage the development of open data in the user’s measurement of high-speed Internet.