Top 4 tricks to use cell ranges in excel formulas

Creating formulas in Excel is very important for the advanced and mid level users in interpreting data. Before creating any formula you must be aware of the data and the desired result. Without a perfect data and logic for a desired result, no formula can give you accurate results.  At times, you may need to provide a range of cells instead of indicating to a single specific cell.

Here are some basic steps to use the cell ranges in any Excel formula:


The first step is to start your formula by clicking in the specific cell where you want the result of the particular formula. All the logics will be applied in this particular cell and the result of the formula will also be displayed in the same cell.


Now type in the equal symbol (=) in this cell to begin the formula logic and use the below mentioned syntax which refers to a range of cells in an individual column B10:B20.  This denotes the complete range starting from cell B13 till B25. You can also use the similar formula type to represent another range of cells in an individual row like A1:A13


You can also refer to the shortcut like A:A  or A:D which can be used to represent for a series of column and similar construction can be used for rows.


Now add the formula to make the Sum of the column or rows like =Sum (B2:B8) and hit Enter button to get the desired result.

Leave a Reply

Your email address will not be published. Required fields are marked *