Overview

Add up a column of numbers

Find the middle of a set of numbers

Count numbers, or count anything at all

Do one thing when true, another when false

Count only the rows that meet a condition

Add up only the rows that meet a condition

Count rows that meet several conditions at once

Add up rows that meet several conditions at once

The older lookup you will still meet in real files

Find a row by one value, bring back another

Find the smallest and largest numbers in a range

Control how many decimal places a result keeps

Test whether every condition or any condition is true

Replace formula errors with a useful result

Extract a useful part from a text code

Clean stray spaces and measure text length

Join text and cell values into one result

Find a position, then return the value at that position

Pick the columns you want and drop the rows you do not

Put the rows in an order that means something, then take the top few

Ask what values exist without being handed the same one ten times

Turn a column of numbers into one number that answers the question

One row per region instead of one per order

Two tables, one result, matched on the column they have in common

Turn a number into a word people can actually read

Let one query work out the number the other one needs