📊 Lesson 2.2: Everyday Functions — SUM, AVERAGE, COUNT, IF, ROUND & TODAY

What a Function Is

A function is a named, pre-built formula that Google has already written for you. You supply the inputs; it does the work. Where last lesson you might have written =A2+A3+A4+A5, a function lets you write =SUM(A2:A5) — shorter, clearer, and it still works if you add more rows to the range. Sheets ships with hundreds of these, but you'll do 80% of your work with the dozen or so we cover in this module.

Every function has the same shape, and once you can read it, you can read them all:

=NAME(argument1, argument2, …)

• The = — same as any formula; it says "calculate this."
• The NAME — what the function does, like SUM or AVERAGE. Not case-sensitive; sum and SUM both work.
• The parentheses — every function has them, even ones that take nothing inside, like =TODAY().
• The arguments — the inputs you feed it, inside the parentheses, separated by commas. An argument can be a number, a cell, a range, or even another formula.

Let the autocomplete helper guide you

You don't have to memorize function names or the order of their arguments. Start typing =SU in a cell and Sheets pops up a suggestion list; keep going and it shows a little tooltip describing the function and naming each argument as you type it. This helper is your always-on cheat sheet — read it, and it tells you exactly what to put where. Press Tab to accept a suggested function name.

The Core Math Family

These four are the workhorses. All of them take a range (remember the colon from last lesson: A2:A10 means A2 through A10) and boil it down to a single number.

The star of the group is SUM, and there's a lovely shortcut for it. Click an empty cell just below a column of numbers and press Alt+= (if that shortcut doesn't respond in your browser or keyboard layout, use the Σ Functions toolbar button, or Insert → Function → SUM). Sheets guesses the range above and writes the SUM for you — press Enter to accept. It's the fastest way to total a column.

You can also mix in multiple ranges or single cells with commas: =SUM(B2:B10, D2:D10) adds two separate columns, and =SUM(B2:B10, 100) adds a flat 100 to the total. But the everyday form — one clean range — is what you'll reach for most.

⚠️ Important Note: These math functions quietly skip empty cells and text. =AVERAGE(B2:B10) averages only the cells that actually hold numbers — a blank row won't drag your average down to zero. That's usually helpful, but it means you should know how many values you're really averaging, which is exactly why counting (next section) matters.

Counting — COUNT vs COUNTA

"How many entries do I have?" sounds trivial until you realize there are three different counting functions and picking the wrong one is one of the most common beginner mistakes. Here's the honest breakdown:

Here's the gotcha in a sentence: COUNT only counts numbers. If you point =COUNT(A2:A100) at a column of names, it returns 0 — because names aren't numbers — and beginners conclude the function is broken. It isn't; it's doing exactly its job. To count a list of names (or any non-empty cells), you want =COUNTA(A2:A100). The letter A stands for "all types."

A tiny worked example. Suppose A2:A6 holds: 12, "Pending", 8, (blank), 5. Then =COUNT(A2:A6) is 3 (only the three numbers), =COUNTA(A2:A6) is 4 (three numbers plus the word "Pending"), and =COUNTBLANK(A2:A6) is 1 (the empty cell). Same range, three different answers — that's why choosing the right one matters.

IF — Making the Sheet Decide

So far our functions crunch numbers. IF does something new: it lets your sheet make a decision and put different results in a cell depending on the answer. This is the gateway to spreadsheets that feel smart — flagging problems, labeling categories, applying rules.

An IF takes exactly three arguments, in this order:

=IF(logical test, value if true, value if false)

• Logical test — a true/false question, built with the comparison operators from last lesson (>, <, =, and friends). For example B2>100.
• Value if true — what to show if the test is true.
• Value if false — what to show if the test is false.

A concrete example. You have spending amounts in column B and a budget of 100 per row. You want each row labeled "Over budget" or "OK":

=IF(B2>100, "Over budget", "OK")

Read it as a sentence: "IF the value in B2 is greater than 100, show Over budget, otherwise show OK." Note two things. First, text results go in double quotes — "Over budget" — while numbers and cell references don't. Second, copy this down the column and the relative reference B2 shifts to each row, so every row gets judged against its own value. Here's the decision as a flow:

⚠️ Important Note: The most common IF mistakes are forgetting the quotes around text results, and mixing up the comma order. If your IF won't accept, count three parts separated by two commas, and check every piece of text is quoted. The autocomplete tooltip bolds the argument you're on — lean on it.

Rounding & Dates

Rounding — especially for money

Divide 10 by 3 and you get 3.33333333… trailing off forever. On screen a cell might display a tidy 3.33, but underneath it still stores the long value — and that can make totals look a penny off. ROUND actually changes the stored number to a set number of decimal places:

=ROUND(3.14159, 2)   →  3.14
=ROUND(2.5, 0)       →  3
=ROUND(B2, 2)        →  B2 rounded to 2 decimals (cents)

The second argument is how many decimal places to keep — 2 for money (cents), 0 for whole numbers. There are two cousins for when you always want to go one direction: ROUNDUP always rounds away from zero, and ROUNDDOWN always rounds toward zero. Use plain ROUND for money and most everyday needs.

Dates — TODAY and NOW

Two functions put the current date and time into your sheet. Both take no arguments — but you still write the empty parentheses:

• =TODAY() — today's date (no time). Great for "as of" labels and for date math like days remaining.
• =NOW() — the current date and time.

These are called volatile functions: they don't freeze at the moment you type them. They recalculate — TODAY() rolls over to the new date each day, and both refresh whenever the sheet recalculates. That's perfect for a live "Last updated" stamp, but if you need a permanent timestamp that never changes, type the date by hand or paste it as a value instead. We dig into how dates really work — they're secretly just numbers — in Lesson 2.3.

🎯 Project: A Summary Block

Let's turn a plain list of data into something that summarizes itself. Open the dataset you built in Module 1 (or make a quick one: a column of expense amounts with a category and description). You'll add a small "summary block" of the functions from this lesson, plus an IF label on each row. By the end, changing any number will ripple through every summary line — the living-model feeling again, now powered by functions.

Total            =SUM(C2:C11)
Average          =AVERAGE(C2:C11)
Highest          =MAX(C2:C11)
Count of amounts =COUNT(C2:C11)
Count of entries =COUNTA(A2:A11)
Rounded average  =ROUND(AVERAGE(C2:C11), 2)
Last updated     =TODAY()

Status column (row 2, then copy down)
=IF(C2>100, "Over budget", "OK")

Best Practices with Functions

✅ Do's

• Let autocomplete teach you. Read the tooltip; it names each argument so you never have to memorize argument order.
• Match the count function to the data. Numbers → COUNT; entries of any kind → COUNTA; gaps → COUNTBLANK.
• Round money on purpose. Use ROUND(…, 2) when a value feeds further math, so the numbers match what people see.
• Read IF as a sentence. "If test, then this, else that" — three parts, two commas.

❌ Don'ts

• Don't forget the parentheses. Even zero-argument functions need them: =TODAY(), not =TODAY.
• Don't leave text unquoted in IF. "Over budget" needs its quotes; a bare word errors out.
• Don't use TODAY() for a fixed date. It changes daily — type the date by hand when you need a permanent record.

📓 Learning Journal

📝 Lesson Summary

🎉 What You've Accomplished

Your dataset now summarizes itself: it totals, averages, counts, rounds, stamps the date, and judges each row with a rule you wrote. You've gone from typing arithmetic to commanding a toolkit of functions — and you met IF, the first step toward sheets that reason. That's a genuinely big leap in capability.

❓ Common Questions at This Stage

🔭 Looking Ahead

In the next lesson — Lesson 2.3: Text & Date Functions — TEXTJOIN, LEFT/RIGHT/MID & Working with Dates — we turn to messy text and to how dates really work under the hood (spoiler: a date is secretly just a number). You'll clean, split, and combine names and contact data with formulas instead of retyping.

✅ Before the Next Lesson

• Confirm your summary block updates when you change a data value
• Make sure you can explain the difference between COUNT and COUNTA
• Write your Learning Journal entry, including one plain-English IF

📚 Additional Resources

• Google Sheets function list (Google Support)
• SUM function reference (Google Support)
• Explore functions in your own sheet
• sheets.google.com — practice with your data