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

The best Linux web hosting services of 2018

Linux hosting is everywhere. Whether you're looking for a simple shared hosting account or a powerful dedicated server, the chances are that you'll be offered a Linux-based option first. In many cases, you might not care. If your hosting needs are simple, you'll probably choose an account based on the allocated web space, bandwidth and similar features – the operating system is so far down most people's priority list that often it's not even mentioned in comparison tables. Read more

Security Leftovers

today's howtos

KaOS 2017.11 review - Chaotic and unfriendly

KaOS 2017.11 feels like a very buggy product. While I do like the Nvidia setup right from the start, this little gem is offset by pretty much everything else. Most other recent distros rarely had any issues with the LG RD510 laptop - apart from the ATA link reset on wake after suspend, which affects all of them - but KaOS is an exception to that rule with a rather depressing hardware record - Bluetooth, Wireless no-reconnect, smartphone support. And let's not even talk about Samba. The responsiveness was quite bad, Kaptan did not work, and I wasn't enjoying the visual side of things one bit. In fact, I really do not understand the eye-killing choices that go with the default theme. All in all, there are very few redeeming factors to KaOS. If you're looking for something avant-garde, the Arch-based Antergos or Manjaro fit the bill rather well. If you want mainstream, Mint or Ubuntu or whatever. This falls somewhere in between, with nothing amazing in return. 2/10. Perhaps next time. Read more