'Lock' part of formula when copying from one cell to another

Question

I have the following formula in a Google Spreadsheet:

=IF(I11="VSS";G11;IF(I11="MCS";0;G11*Totais!C30))

I would like to freeze Totais!C30 when I click on bottom right of cell and drag down.

Currently when I do this, Totais!C30 change to Totais!C31, Totais!C32, C33...

Answer 1

By adding a $ in front of the column & row you can lock that specific area up when copying.

Example: Totais!$C$30 would lock down when copying anywhere else in the document. Totais!$C30 would lock down moving column to column. Totais!C$30 would lock down when moving down rows.

Answer 2

Don´t know how to do post the same question with a more specific situation so here it goes (any correction would be most appreciated). My spreadsheet is as shown in next images. You can see the formula i used in cell C5 and as you can notice i'm trying to freeze the reference to cell P15. But when i create a new row at row 8 (see image 2) Google-s spreadsheet seems to be ignoring my request to freeze reference to cell P15 done in formula contained in cell C5! Notice that i'm using frozen rows for the first 5 rows. Thanks