Google Sheets, without the guesswork

Every function with a worked example that was actually run in a spreadsheet — plus free tools that write the formula for you.

• Lookup

  Find a value in one place and pull back a matching value from another.

  • INDEX
  • MATCH
  • VLOOKUP
  • XLOOKUP
• Logical

  Make the sheet decide: test a condition and branch on the answer.

  • IF
  • IFERROR
• Math & aggregation

  Add up, count and average — usually with a condition attached.

  • COUNTIF
  • SUMIF
  • SUMIFS
• Text

  Join, split and reshape text.

  • SPLIT
  • TEXTJOIN
• Array & filter

  Work on whole ranges at once instead of dragging a formula down.

  • FILTER
  • QUERY
  • SORT
  • UNIQUE