# CONSTANT CELL IN FORMULA

#### wallcm

##### New Member
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").

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

#### lenze

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

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

##### MrExcel MVP
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

##### New Member
Thank you again worked perfectly.

Replies
1
Views
193
Replies
3
Views
300
Replies
11
Views
1K
Replies
1
Views
281
Replies
6
Views
139

1,195,664
Messages
6,011,015
Members
441,579
Latest member
satishrazdhan

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back