Question

Write down the formula in Excel to find the average of the cell range starting from row 10 column B to row 10 column D

Answer 1

Answer:

this in formula

Explanation:

Enter the sample data on your worksheet

In cell A7, enter an AVERAGE formula, to average the numbers in column A: =AVERAGE(A1:A5)

Excel AVERAGE Function

Press the Enter key, to complete the formula.

The result will be 21.83, the average of the cells that contain numbers.

Cell A1 isn't included in the average, because it contains text, and the empty cell C3, is ignored.

Answer 2

Answer:

I am looking to do summary statistics on a column of varying lengths.  

I want to do something like =sum(A:A) except I want to avoid the first 5 rows of column A. Is there a way to do it?  

EDIT: Someone pointed out a possible duplicate. Except neither of the solutions in that question actually works. If someone is proposing to apply ISBLANK() to the whole column until the maximum index, I would like to see clarification on the different between that and formats such as A:A -- in terms of speed.