Get started on how to create formulas and use built-in functions to perform calculations and solve problems.
We've put together a Get started with Formulas workbook that you can download. If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour. With real-world examples and helpful visuals, you’ll be able to Sum, Count, Average, and Vlookup like a pro.
You can browse through the individual sections below to learn more about specific formula elements.
To refer to | Use |
---|---|
The cell in column A and row 10 | A10 |
The range of cells in column A and rows 10 through 20 | A10:A20 |
The range of cells in row 15 and columns B through E | B15:E15 |
All cells in row 5 | 5:5 |
All cells in rows 5 through 10 | 5:10 |
All cells in column H | H:H |
All cells in columns H through J | H:J |
The range of cells in columns A through E and rows 10 through 20 | A10:E20 |
Reference | Meaning |
---|---|
R[-2]C | A relative reference to the cell two rows up and in the same column |
R[2]C[2] | A relative reference to the cell two rows down and two columns to the right |
R2C2 | An absolute reference to the cell in the second row and in the second column |
R[-1] | A relative reference to the entire row above the active cell |
R | An absolute reference to the current row |
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.