I have the formula bellow on a Google Spreadsheet file:

=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...

Is there a way to do it?

Thank you.