<div>
=OFFSET(X5,-1,-3) where formula is in X5.. the current row
</div>


=OFFSET(X5,-1,-3) where formula is in X5.. the current row

<div>
yes, but I need to put it in the current formula so that I always reference the (-1,-3)
</div>


yes, but I need to put it in the current formula so that I always reference the (-1,-3)

<div>
not sure what you mean... can you give example of &quot;current formula&quot; and what you need?
</div>


not sure what you mean... can you give example of "current formula" and what you need?

<div>
IFERROR(SUMIF(INDIRECT(&quot;'&quot;<wbr />&amp;TEXT($D$2<wbr />1,&quot;dd-mmm-<wbr />yyyy&quot;)&amp;&quot;'!<wbr />$A$3:$A$14<wbr />&quot;),H$3,IND<wbr />EX(INDIREC<wbr />T(&quot;'&quot;&amp;TEXT<wbr />($D$21,&quot;dd<wbr />-mmm-yyyy&quot;<wbr />)&amp;&quot;'!$A$3:<wbr />$Q$14&quot;),,M<wbr />ATCH($D22,<wbr />INDIRECT(&quot;<wbr />'&quot;&amp;TEXT($D<wbr />$5,&quot;dd-mmm<wbr />-yyyy&quot;)&amp;&quot;'<wbr />!$A$3:$Q$3<wbr />&quot;),0))),0)<wbr /><br />
<br />
This formula is in H22 and I want to always one row up and 3 rows left. &nbsp;in this instance I would return D1
</div>


IFERROR(SUMIF(INDIRECT("'"&TEXT($D$21,"dd-mmm-yyyy")&"'!$A$3:$A$14"),H$3,INDEX(INDIRECT("'"&TEXT($D$21,"dd-mmm-yyyy")&"'!$A$3:$Q$14"),,MATCH($D22,INDIRECT("'"&TEXT($D$5,"dd-mmm-yyyy")&"'!$A$3:$Q$3"),0))),0)

This formula is in H22 and I want to always one row up and 3 rows left.  in this instance I would return D1

<div>
IFERROR(SUMIF(INDIRECT(&quot;'&quot;<wbr />&amp;TEXT($D$2<wbr />1,&quot;dd-mmm-<wbr />yyyy&quot;)&amp;&quot;'!<wbr />$A$3:$A$14<wbr />&quot;),H$3,IND<wbr />EX(INDIREC<wbr />T(&quot;'&quot;&amp;TEXT<wbr />($D$21,&quot;dd<wbr />-mmm-yyyy&quot;<wbr />)&amp;&quot;'!$A$3:<wbr />$Q$14&quot;),,M<wbr />ATCH($D22,<wbr />INDIRECT(&quot;<wbr />'&quot;&amp;TEXT($D<wbr />$5,&quot;dd-mmm<wbr />-yyyy&quot;)&amp;&quot;'<wbr />!$A$3:$Q$3<wbr />&quot;),0))),0)<wbr /><br />
<br />
This formula is in H22 and I want to always one row up and 3 rows left. &nbsp;in this instance I would return D21
</div>


IFERROR(SUMIF(INDIRECT("'"&TEXT($D$21,"dd-mmm-yyyy")&"'!$A$3:$A$14"),H$3,INDEX(INDIRECT("'"&TEXT($D$21,"dd-mmm-yyyy")&"'!$A$3:$Q$14"),,MATCH($D22,INDIRECT("'"&TEXT($D$5,"dd-mmm-yyyy")&"'!$A$3:$Q$3"),0))),0)

This formula is in H22 and I want to always one row up and 3 rows left.  in this instance I would return D21

<div>
What do you mean by this instance would return D1? &nbsp;Where?
</div>


What do you mean by this instance would return D1?  Where?

<div>
that's exactly it.<br />
Thanks
</div>


<div>
<div class="content wysiwyg-content">
Morning experts. &nbsp;Does anyone know how to reference the current cell minus 3 columns minus 1 row?<br />
Thanks
</div>
</div>


Morning experts.  Does anyone know how to reference the current cell minus 3 columns minus 1 row?
Thanks

Offset current cell

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