Topic: How do the fuck do you use formulas in Google Drive spreadsheets?

Anonymous A started this discussion 12 years ago #35,718

This is confusing as fuck.

Anonymous B joined in and replied with this 12 years ago, 3 hours later[^] [v] #489,786

> How do the fuck do you

Hi Catherine!

Anonymous C joined in and replied with this 12 years ago, 17 minutes later, 4 hours after the original post[^] [v] #489,788

Hey there, Cathy! Ha ha ha!

Anonymous D joined in and replied with this 12 years ago, 2 hours later, 7 hours after the original post[^] [v] #489,794

Uhh. The same way you use excel formulas...? It's really not that hard, it's just spreadsheets. For some general help from google see https://support.google.com/docs/answer/46977?hl=en, and the list of functions they support is https://support.google.com/docs/table/25273?hl=en (Keep in mind, the functions google docs & excel support differ. There are similarities, but this is not guaranteed).

So, quick example, say you have a spreadsheet that has a single column (A), and the rows 1-5 contains numbers (see image), and then you want to calculate the sum of all the numbers in that row. You go to the list of functions, search for sum, and then you find "SUM(value1, value2)", so what you do is you click on a new cell, say B1, and at the top next to Fx you type in =SUM(A:A), and the cell B1 will now contain the sum of all items on row A. If you only want to sum a subset of items from row A (say, only the first 3), you'd do =SUM(A1:A3). Keep in mind that after you type =SUM(, you can click on a cell to have its value prefilled into the function box.

Anonymous A (OP) replied with this 12 years ago, 2 days later, 2 days after the original post[^] [v] #490,134

@previous (D)
I also discovered that Google Drive has a button for these exact formulas too. I figured most of it out, but I didn't know about =SUM(A:A) for just the column.

Minichan