Formula templates
Pick a starter — we'll fill in your request so you can run it right away.
Totals & sums
- Add up paid rows only
Sum amounts when a status column says paid.
- Running total down a column
Cumulative sum as you go down the sheet.
- Average ignoring blanks
Average of a column skipping empty cells.
- Each row as % of total
Show share of the whole column.
- Highest value per category
Max within each group.
- Combine first and last name
Join text from two columns.