How to do it in Excel

Short answers to everyday tasks. Each one gives the formula first, then shows it working in a sheet you can change, with the common variations and what to watch out for.

Counting

Sums and averages

Lookups

Text

Dates

Percentages and rounding