In Cell B11 Enter A Formula

Excel formula? 3

In cell B11, enter the corresponding cell reference formula that adds values from the range B4: B10.

I don't know if it's = B4 * B10 or = B4 + B10

Thank you for your help.

Your question suggests that formulas should be relevant citations rather than absolute citations.

Absolute reference refers to the column letter and row number of the cell, ie B4.

Relevant reference refers to the row number and column number, i.e. the corresponding reference to B4 is cell R2, C4 (row 2, column 4). References to other cells are expressed as the addition or subtraction of the active cell. So if the active cell is B4 and you want to refer to cell C6 in relative terms, then the input is R [2], C [1]. This corresponds to the active cell row (4) + 2 and the active column (2 or B) + 1.

So in cell B11 your formula is:

= SUM (R [7] K: R [1] K)

The translated formula will count the sum of 7 rows from 11 to 1 less than 11 rows. Since reference C has no offset, add it to the same column. Therefore, 7 rows less than 11 will be 4 in the same column (B) or B4, and less than 11 rows will be 10 in the same column or B10.

Tip: To convert Excel to absolute formula (= Sum (B4: B10) into relative reference formula (= SUM (R [7] C: R [1] C))):

Enter the Absolute = Sum (B4: B10) formula in cell B11.

Go to File> Options> Formula.

In the Use formulas section, select the R1C1 reference style checkbox and click OK.

Select cell B11 and look for the modified formula in the formula bar.

Once this is done, reverse the process and remove the checkmark in R1C1 reference style.

= SUM (B4..B10)

If I have = B4 * B10 then the values of B4 and B10 will be multiplied.

If I had = B4 + B10 I would just combine these two values together.