In this entryway, stone tiles run right down the middle of the hall with wood on either side, almost like a carpet. I love the tone-on-tone look of the dark espresso color for both materials. Inspiration for a contemporary front door in Toronto with a single front door and a dark wood front door.
Example 1 - Omitting the Reference Argument with the ROW Function. 1  Click on cell B2 to make it the active cell; 2  Type the formula =ROW() into the cell. 3  Press the Enter key on the keyboard to complete the function;  The number  2  should appear in cell B2 since the function is located in second row of the worksheet;
If you want to use the SUM function on only the odd rows or the even rows in a range, you can use the following formulas. Enter the following formula as an array formula in cell A4:The formula returns a value of 2.hen you use any of the worksheet functions in Excel, and you have a range argument that includes either hidden rows or columns, the cells in these hidden areas are still used by the function.