CONSTANT CELL IN FORMULA

[wallcm]

I am hoping someone can answer this simple questions. How can I make the 'P3' in a formula a constant even if rows are inserted.

Example =SUMIF(P3:P1517,">1").

 

[lenze]

=SUMIF($P$3:P1517,">1")

See the Help files for a discussion on Absolute and Relative Cell References

 

[Aladin Akyurek]

On 2002-09-17 08:22, wallcm wrote:
I am hoping someone can answer this simple questions. How can I make the 'P3' in a formula a constant even if rows are inserted.

Example =SUMIF(P3:P1517,">1").

=SUMIF(INDIRECT("P3"):P1517,">1")

 

[wallcm]

Thank you again worked perfectly.