<div>
For that you have to use Offset formula for example if the above formula is in B2 then you can also use the following<br />
<br />
=(OFFSET(B2,0,4,1,1)+OFFSE<wbr />T(B2,0,5,1<wbr />,1)+OFFSET<wbr />(B2,0,6,1,<wbr />1))<br />
<br />
Sid
</div>


For that you have to use Offset formula for example if the above formula is in B2 then you can also use the following

=(OFFSET(B2,0,4,1,1)+OFFSET(B2,0,5,1,1)+OFFSET(B2,0,6,1,1))

Sid

<div>
You can also use the INDIRECT function of Excel<br />
<br />
=SUM(INDIRECT(&quot;F2:H2&quot;))/2<br />
<br />

</div>


You can also use the INDIRECT function of Excel

=SUM(INDIRECT("F2:H2"))/2



<div>
Worked like a champ! Thank you very much! <br />
<br />
I was starting to wonder if I was loosing my mind or something.
</div>


Worked like a champ! Thank you very much!

I was starting to wonder if I was loosing my mind or something.

<div>
<div class="content wysiwyg-content">
Gents and Ladies,<br />
<br />
I'm a little bit embarrassed to ask such a seemingly easy question, but I have somewhat of an issue that is really getting under my skin here.<br />
<br />
In one cell I have a straightforward and simple formula (For example: =(F2+G2+H2)/2))<br />
<br />
My problem is that when i insert a a column the formula changes to =(G2+H2+I2)/2 regardless of the cell reference being absolute or not. &nbsp;I would like the formula to always refer to the same cell no matter if I insert a column or not. (In other words, the formula to remain unchanged)<br />
<br />
I'm absolutely stymied by this.<br />
<br />
Please help.<br />
<br />
:)<br />
<br />
Thank you.
</div>
</div>


Gents and Ladies,

I'm a little bit embarrassed to ask such a seemingly easy question, but I have somewhat of an issue that is really getting under my skin here.

In one cell I have a straightforward and simple formula (For example: =(F2+G2+H2)/2))

My problem is that when i insert a a column the formula changes to =(G2+H2+I2)/2 regardless of the cell reference being absolute or not.  I would like the formula to always refer to the same cell no matter if I insert a column or not. (In other words, the formula to remain unchanged)

I'm absolutely stymied by this.

Please help.

:)

Thank you.

Cell references

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.