Fungen Activity generator
learn a spreadsheet function
Skills

Learn a Spreadsheet Function: SUM, IF and COUNTIF

Learn one spreadsheet function by applying it to a small table you understand.

Time:
60 min
Cost:
free
Difficulty:
moderate
Where:
Indoors
Best:
Solo

Learn one spreadsheet function by applying it to a small table you understand. SUM adds values, IF chooses between results based on a condition, and COUNTIF counts cells matching a criterion. Start in a disposable practice sheet so you can change inputs and see what the formula does.

A small spreadsheet function exercise

Put the numbers 10, 20 and 30 in B2:B4. Enter “=SUM(B2:B4)” elsewhere; the result is 60. Try “=IF(B2>15,"Over","Within")”, which returns Within for 10. Then try “=COUNTIF(B2:B4,">15")”, which counts two values. The quoted words and criterion are part of the formula.

Change B2 to 25 and predict the result before checking it. Some regional settings use semicolons in place of commas. If a formula appears as text, check the leading equals sign and cell format. Apply the function to your real sheet only after the example behaves as expected.

Why learn a new Excel/Google Sheets function is worth an hour

A manageable first session lets you check the instructions, try an appropriate starting point and decide what to do next. Review what suited your circumstances before increasing the scope or committing to a longer plan.

How to learn a new Excel/Google Sheets function step by step

  1. 1

    Prepare

    Create a small practice table with known values.

  2. 2

    Try the practical steps

    Enter one example formula and predict the result before checking it.

  3. 3

    Review and follow up

    Change an input and verify that the result updates as expected.

Tips to get more out of it

  • SUM is a useful first choice because you can check it by adding a few values yourself. Add IF or COUNTIF when you need a condition or a count.

Ways to mix it up

You can use the session to read the linked guidance and plan a suitable next step. If the suggested activity does not fit today, choose a smaller version or ask for individual advice where needed.

For more ideas, browse skills activities.

Another activity to try is learn keyboard shortcuts for your os.

Learn a new Excel/Google Sheets function: frequently asked questions

Which spreadsheet function should a beginner learn first?

SUM is a useful first choice because you can check it by adding a few values yourself. Add IF or COUNTIF when you need a condition or a count.

Was this helpful?
Share:

Related activities

Skills

Learn data visualization basics

Discover how to turn raw numbers into honest, easy-to-read charts.

Skills

Learn about business analytics

Explore how businesses use data to make decisions, from KPIs to dashboards.

Skills

Learn keyboard shortcuts for your OS

Master a handful of system shortcuts that will save you minutes every single day.