|2. Cell Referencing|
|3. Data Types|
|6. Intro To Logic|
|7. Simple Math|
|8. Math & Logic|
|9. Changing Text|
|10. Replacing Text|
|11. Splitting Text|
|12. Joining Text|
|13. Sorting Data|
|14. Rearranging Data|
|15. Looking Up Data|
Functions are the lifeblood of spreadsheets.
They're amazing little tools that take data in, calculate or manipulate it, and return the new data you need.
A function in a formula bar looks like this:
You'll get to know the name of many functions from the hundreds available to you.
Some of the more common functions include SUM, AVERAGE, COUNT, MIN, MAX.
The data points you feed these functions (e.g. data1,data2) are called 'arguments'.
Functions can require a certain number of arguments (including none at all), others can take as many arguments as needed, and some have optional arguments that are only required for the function to work in a specific way.
Let's use the SUM function as an example.
SUM returns the sum of a series of numbers and/or cells.
SUM can take numbers, cell references, cell ranges, or a combination of all three.
The square brackets around [value2, ...] mean it's optional.
The ellipsis (...) at the end means that SUM can take as many arguments as you need. The only required argument is the first one.
Functions within functions
The beauty of spreadsheet functions is that they can be ‘nested’.
This means an argument for one function can be the output of another.
Let’s use the following sales data as an example:
You want to get the total sales for the three months.
You could do this using any of the following (with the last being the easiest to understand and therefore the best):
You could also do the following:
This shows what nesting looks like.
Each argument to the outer SUM function is itself a sum function. You’re summing the sum of each year’s sales figures.
The internal SUM functions SUM(B2:B6),SUM(C2:C6),SUM(D2:D6) are executed first with the values they return then used are arguments to the outer SUM function: =SUM(19000, 28000, 25650).
It’s not the best way to use the sum function, but it shows that the arguments of one function can be the output of another.
Google Sheets Cheat Sheet
12 exclusive tips to make user-friendly sheets from today:
You'll get updates from me with an easy-to-find "unsubscribe" link.