How to Use Cell Ranges in Excel Formulas
When creating formulas in Microsoft Excel 2000, you can indicate a range instead of specifying each individual cell to use.
Other People Are Reading
Instructions
-
-
1
Begin your formula by clicking in the cell you want the formula to go in.
-
2
Type an equal sign (=).
-
-
3
Use the following syntax to refer to a range of cells in a single column: B13:B25. (This indicates cell B13 through cell B25.)
-
4
Type a similar construction to indicate a range of cells in a single row: A12:F12.
-
5
Use the following shortcut to refer to all the cells in a column: D:D. For a series of columns, you'd use something like D:H. Similarly, to indicate rows 3 through 18, you'd use 3:18.
-
6
Add a formula for summing a column of cells, for example: =SUM(B3:B10).
-
7
Press Enter to finalize the formula.
-
1
Tips & Warnings
You can name cells or ranges to make formulas easier to understand. (See Related eHows.)
More Like This
Comments
View all 6 Comments-
very good
-
Abdullah Siddiqui
Jan 22, 2011
very helpful! Thanks a lot -
Stashia Smith
Oct 11, 2010
how do you auto fill a formula like this: =total/ref cell=percentage of total
-
Stashia Smith
Oct 11, 2010
ho
-
Nov 22, 2005
Lotus 123 uses cell ranges such as "A1..B5". Note: The ".." instead of Excel's ":". Excel will, however, convert the ".." or "." to ":" automatically.
